OdooWiki OCA HUB

Use AND conditions on omnibar search

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

When searching for records on same field Odoo joins multiple queries with OR. For example:

  • Perform a search for customer "John" on field Name
  • Odoo displays customers containing "John"
  • Search for "Smith" on same field Name
  • Odoo displays customers containing "John" OR "Smith"

With this module installed you can press Shift key before searching for "Smith" and Odoo finds customers containing "John" AND "Smith"

auto_awesome What this module does

AI-generated from the code · Odoo 19.0

Lets users combine several search terms on the same field with AND instead of OR by holding the Shift key while picking a search suggestion in the omnibar.

Normally, when you search twice on the same field in Odoo's search bar, the results match either term (OR). This module changes that behaviour when you hold the Shift key.

  • Type a first term in the search bar and select it as usual.
  • Then type a second term on the same field, hold Shift and press Enter (or click the suggestion) to add it.
  • Odoo then shows only records that match both terms at the same time.

The change is purely in the search bar and the search engine behind it, so it works on any list or kanban view that uses the standard search bar. No new menus, buttons or reports are added, and no business data is modified.

Technically, the module patches the search bar and search model so that a suggestion chosen with Shift is placed in its own search group, which makes the resulting filter an AND condition. It also keeps the normal behaviour when Shift is not used, and the existing way of removing a filter group still works.

Depends on

web

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

terminal Installation and usage

OCA documentation · Odoo 19.0
  • Enter your value in omnibar search field
  • Press and hold Shift key
  • Select field with mouse or keyboard to perform search on

[](https://runbot.odoo-community.org/runbot/162/11.0)

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.