OR condition in the Search bar

Question

In V.14 I want to select my products based on multiple filters, and have the products come up if it only meets the conditions in one of the filters. However currently the search bar only returns queries that contain all filters. I consider this to be an AND condition, and I would like to change it to an OR condition. Is this possible through a Studio customization? The database contains Sales, Inventory, Purchase, Manufacturing and Studio.

Michael Dijkstra (mdj) · Accepted Answer

So the answer is quite straightforward. Adding in a Custom Filter gives the option for OR automatically, one has to add a % between both filgets to make it an AND condition.

Jainesh Shah(Aktiv Software) · Answer

Hello Michael,
Please try with following steps:
First extend the input widget
var Input = Widget.extend( /* @lends instance.web.search.Input# /{
For specific model you can give condition like this:
if (self.searchview.action.env.modelName == 'hr.applicant')
In the base in the return AND condition is defined , you have to change with OR like this:
return pyUtils.assembleDomains(domains, 'OR');
e.g.
var Input = Widget.extend( /* @lends instance.web.search.Input# /{
if (self.searchview.action.env.m

Related Posts	Replies	Zobrazenia
How to add a related field coming from a sales order on an invoice? Solved quickstart Studio	2 máj 25	7708
How to filter the customers in the Sales Order for the salesperson? Solved quickstart Studio	1 mar 23	3674
Studio : add a specific field (SIRET) in the header of PDF documents quickstart Studio	0 júl 21	444
Adding a column in Replenishment Studio v14 replenishment	2 nov 23	2516
Many2Many filter \| Odoo V14 \| Odoo Studio Solved many2many Studio v14	1 dec 22	4017

This question has been flagged

Enjoying the discussion? Don't just read, join in!