Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

All apps

how to set multiple conditions in search method in odoo9

1 Odpowiedz

18157 Widoki

i want to set multiple (&) and (|) in single search method.

i have these Many2many field-

self.env.[sale.order].search(

(saleorders ID in m2m OR all ID) AND (customers ID in m2m OR all ID) AND (salespersons in m2m OR all ID)

Hello

I will link you to an existing answer which breaks down the process nicely:

https://www.odoo.com/en_US/forum/help-1/question/domain-notation-using-multiple-and-nested-and-2170

Essentially, you want to solve the order by abstracting the search logic and then re-adding your details afterwards.

I think (I have not tested) your search would break down to:

AND AND OR A B OR C D OR E F

Once I substitute your values back in, you would be left with:

'&', '&', '|', (saleorders ID in m2m), (all ID), '|', (customers ID in m2m), (all ID), '|', (salespersons in m2m), (all ID)

Again, I'm not certain that logic will work, but you should be able to come close with the process described in the link above.

Good luck!

Autor

Hello Travis,

actually, i have problem like this.

all r M2M and search in sale_order with IN condition.

search( [( A & B & C & D) or (A & B & C) or (A & B) or (A) or (B) or (C) or (D)])

how to set conditions like above . please give me any solution.

However, for the search you commented, I think you should be able to simplify it a lot (assuming there are only 4 variables total).

It would be able to break down to: search([A OR B OR C OR D])

In Polish Notation: search(['|', '|', '|', (A), (B), (C), (D)])

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Powiązane posty	Odpowiedzi	Widoki
Condition Drop Down Items domain domain_filter	0 lut 25	18
Error: Failed to evaluate the domain [...] fnValue is not a function filter domain error search domain_filter	0 maj 23	3724
(ODOO 10 How To) Compute domain / Dynamic Domain / set a domain based on a function or a field Rozwiązane domain domain_filter compute domains dymanic_fields	2 wrz 21	23742
Add my own domain via NameCheap in Odoo domain domains	2 gru 20	6427
How can I pass more than one field to a search function? In Odoo 9 Rozwiązane domain view search domain_filter odoo9	6 wrz 20	20831