NaN-tic|Full Text Search with Koo and OpenERP

Koo, the KDE OpenObject client, has supported Full Text Search for quite some time, but not many people know about it.

Once installed, configure the fields to index in Administration > Configuration > Full Text Search > Indexes. After adding the fields, execute Update Full Text Index. Existing data is indexed, and new information is indexed automatically by database triggers, even when records are inserted directly into PostgreSQL.

You can then click Full Text Search in Koo to search for words in any indexed field, model or attachment. Double-clicking a result opens it in a new tab.

Together with the smart_attach module, it can also search inside attached documents, including images processed automatically with OCR. Combined with Koo’s system tray functionality, this provides a fast way to access OpenERP information.

The full_text_search server module is included in Koo’s Bazaar repository, together with the fts-indexes module, which contains standard preconfigured indexes.

Update: PostgreSQL must be configured to use this module.