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	Odgovori	Prikazi
How to add a related field coming from a sales order on an invoice? Solved quickstart Studio	2 maj 25	7753
How to filter the customers in the Sales Order for the salesperson? Solved quickstart Studio	1 mar. 23	3685
Studio : add a specific field (SIRET) in the header of PDF documents quickstart Studio	0 jul. 21	444
Adding a column in Replenishment Studio v14 replenishment	2 nov. 23	2531
Many2Many filter \| Odoo V14 \| Odoo Studio Solved many2many Studio v14	1 dec. 22	4038

This question has been flagged

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