OdooWiki OCA HUB

Wildcard in advanced search

web_advanced_search_wildcard folder_open OCA/web open_in_new
web License: AGPL-3

This module adds new options to advanced search of char, many2one, many2many and one2many fields:

  • starts with (uses the domain =ilike %),
  • doesn't start with (uses the domain not ilike %),
  • ends with (uses the domain =ilike %),
  • doesn't end with (uses the domain not ilike %),
  • matches (uses the domain =ilike ).

auto_awesome What this module does

AI-generated from the code · Odoo 12.0

Adds new wildcard search options to the advanced search filters in Odoo, so users can search text fields by "starts with", "ends with", "doesn't start with", "doesn't end with" and "matches".

This module extends the advanced search filters available in Odoo's search bar for text (char) fields. When a user opens the advanced search and picks a text field, the list of comparison operators now includes extra choices beyond the standard ones.

The new operators are: - "starts with": finds records whose field begins with the typed text. - "doesn't start with": excludes records whose field begins with the typed text. - "ends with": finds records whose field ends with the typed text. - "doesn't end with": excludes records whose field ends with the typed text. - "matches": finds records whose field contains the typed text anywhere.

These options appear directly in the search filter dropdown, so no new menu or screen is created. The module only changes the behaviour of the search bar; it does not add any database fields, reports, emails or scheduled actions. It works on any screen that uses the standard search view, such as list views of customers, products, invoices or any other model with text fields. The search is case-insensitive, so typing lower or upper case letters returns the same results. The module depends on the web module and loads its behaviour through the backend assets.

Depends on

web

Text generated by AI (DeepSeek) from reading the Odoo 12.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: 1 confirmed, 8 with no information of 9 versions.

terminal Installation and usage

OCA documentation · Odoo 12.0

When selecting matches, use % as a placeholder.

Example: "Zip" - 'matches' - "1%" gives all zip starting with 1

Also allows insensitive exact search. Example "Name" - 'matches' - "john" will find "John" and "john" but not "Johnson".

No verified information in OCA: Installation, Configuration.

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.