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

İlgili Gönderiler	Cevaplar	Görünümler
How to add a related field coming from a sales order on an invoice? Çözüldü quickstart Studio	2 May 25	6492
How to filter the customers in the Sales Order for the salesperson? Çözüldü quickstart Studio	1 Mar 23	3152
Studio : add a specific field (SIRET) in the header of PDF documents quickstart Studio	0 Tem 21	444
Adding a column in Replenishment Studio v14 replenishment	2 Kas 23	1796
Many2Many filter \| Odoo V14 \| Odoo Studio Çözüldü many2many Studio v14	1 Ara 22	3398

Bu soru işaretlendi

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