OdooWiki OCA HUB

Fuzzy Search of URL in Attachments

url_attachment_search_fuzzy folder_open OCA/server-tools open_in_new
Tools License: AGPL-3

This module creates a trigram index for the field url in ir_attachment in order to make more efficient sql searches with like operand and this field. In large dbs it can speed up a lot interface loading, for example when logging in.

auto_awesome What this module does

AI-generated from the code · Odoo 16.0

Adds a trigram index on the URL field of attachments so that searching or filtering attachments by URL is much faster on large databases.

This module does not add any new screen, menu or button. It works behind the scenes to make searching attachments by their web address (URL) faster.

When installed, it creates a special database index of type "gin" on the url field of the ir_attachment model, using the fuzzy search framework provided by the base_search_fuzzy module. This index is stored as a trgm.index record.

  • The index targets the URL field of attachments, so lookups that use "contains" or "like" style searches on that field can be answered much faster.
  • It is most useful on large databases, where such searches can otherwise slow down screens that load many attachments, for example when logging in or opening attachment lists.
  • No business rules, checks, default values, emails or scheduled jobs are added by this module.

In short, it is a performance-only module: it changes how the database stores search data for attachment URLs, not what users see or do in Odoo.

Text generated by AI (DeepSeek) from reading the Odoo 16.0 code on GitHub; it may contain mistakes, so check the code before deciding. View the code on GitHub

Availability by version

Reviewed: 2026-11-03
Confirmed (verified in repository and branch) Estimated (unverified) No information

Confirmation status: 3 confirmed, 6 with no information of 9 versions.

Sources · Odoo 16.0

Confirmed on 2026-11-03 in branch 16.0 of OCA/server-tools.

terminal Installation and usage

OCA documentation · Odoo 16.0

Installation

Source · Odoo 16.0

(same as the base module)

  • The PostgreSQL extension pg_trgm should be available. In debian based distribution you have to install the postgresql-contrib module.
  • Install the pg_trgm extension to your database or give your postgresql user the SUPERUSER right (this allows the odoo module to install the extension to the database).

Configuration

Source · Odoo 16.0

You just have to install this module and the Index for 'url' field in ir_attachment model will be automatically created.

No verified information in OCA: Usage.

info

Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.