base_search_fuzzy
This module enables fuzzy search functionality in Odoo by providing the ability to create trigram indexes on text and character fields and supporting the '%' operator for approximate string matching in search domains.
Key Features
- trgm.index: Allows users to create and manage GIN or GiST trigram indexes on char and text fields through a dedicated model.
- search: Supports the '%' operator in search domains for performing fuzzy string matching on indexed fields.
- database: Automatically attempts to install the pg_trgm PostgreSQL extension upon module initialization.
- ui: Provides a menu item under Settings -> Database Structure -> Trigram Index for managing trigram indexes.
- res.partner: Includes demo data to test fuzzy search functionality on partner names.