Full Text Search
Quick summary
Full-text search makes it possible to find information in OpenERP data quickly instead of relying on menu navigation. The article presents the feature and the PostgreSQL-based approach used to implement it.
Contents
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.
Frequently asked questions
What problem does full-text search solve?
It makes it easier to find information in the data without manually browsing options or menus.
What technology is used for text search?
The article presents a text-search solution based on PostgreSQL.
What are the benefits of full-text search?
It allows users to quickly search information distributed across the system through its textual content.
What should be kept in mind about the implementation described?
The article describes the feature and its approach, but it does not provide a complete step-by-step configuration guide.
Related articles
Developer
My life without full text search
Koo’s full-text search provides a fast way to find customer details, worksheets, knowledge-base content and CRM cases. The article highlights the Control + T shortcut and explains why searching can be quicker than browsing menus or relying on individual shortcuts.
Developer
PostgreSQL text-search performance
The article discusses a comparison between PostgreSQL and Oracle text-search performance. PostgreSQL’s capabilities made it possible to implement Koo’s text search quickly and provide fast results from OpenERP data.
Tryton
Koo 5.0 released
Koo 5.0 is a KDE-compatible OpenERP client for Linux, Windows and Mac that combines bug fixes, performance improvements and new features. It can work with all records in list views, perform full-text searches and mass updates, refresh information in real time, display web and multimedia content, and provide extensibility tools for developers.
