base_search_fuzzy

Purpose

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.

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.