Odoo Help


How can I tell Odoo to AND my searches together instead of using OR ? - odoo 10

on 4/14/17, 12:02 PM 1,018 views

Hi I'm using odoo 10 community and I have a question regarding the search bar:

When I'm searching a specific variation in my inventory and I'm using the search bar, odoo automatically add attribute search with an "OR" opérator. is it possible to search several attributes with an "AND" operator. I don't want to use a custom filter since it would be very long to make a search.


thanks for your help!

On 10/20/17, 8:14 AM

hello you can point your resarch to a function called in your  model and test it with boolean field

there is an example

check_maladie_convertie=fields.Boolean(string="Holiday_maladie_Type_to_convert", compute='_check_maladie_type')


    def _check_maladie_type(self):

  holidays=self.env['hr.holidays'].search([("employee_id",'=', self.employee_id.id)])


    ('type', '=', 'remove'),



  for holiday in holidays_maladie:

   holiday.check_maladie_convertie =True


Ray Carnes

--Ray Carnes--
| 9 7 9
Keyport, United States
--Ray Carnes--

Senior ERP Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0 and 11.0.

Completed Odoo Functional and Technical Training.

Functional Areas:

  • CRM/Sales

  • Inventory

  • Manufacturing

  • Accounting

  • Purchasing

Major Skills:

  • Business Process Reengineering

  • Efficiency Consulting

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

I am a skilled Communicator and I only take the serious things seriously!

Ray Carnes
On 4/14/17, 7:36 PM

See https://www.odoo.com/apps/modules/10.0/web_search_with_and/

Use AND conditions on omnibar search

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"

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 4/14/17, 12:02 PM
Seen: 1018 times
Last updated: 10/20/17, 10:34 PM