Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
I want to 'AND', 'OR' condition in single search.
docids = self.env['sale.product.list'].search([ (('branch_id', '=', a_market_id) '&' ('deli_user_id', '=', a_deli_user_id) '&' ('user_id', '=', a_user_id)) '|' (('branch_id', '=', a_market_id) '&' ('deli_user_id', '=', a_deli_user_id) ) ])
Odoo domain is a typical Reverse Polish Notation representative, where operators follow their operands. Look at this wikipedia article for the detailed explanation.
So, '&' and '|' should be before the conditions. '&' might be not set explicitly.
["&", A, B] > both A and B should be satisfied. The same as [A, B]
["|", A, B] > either A or B should be True
["&", A, "|", B, C] > A should be True AND (either B or C should be True)
["|", A, "&", B, C] > Either A should be True OR (both B & C should be True)
Have a look also at the similar Odoo question - https://www.odoo.com/es_ES/forum/ayuda-1/question/domain-notation-using-multiple-and-nested-and-2170
How about this one sir? "['|', '|', '&', A, B, C, D, E]"
I can't understand this domain.
in faOtools' answer, I don't understand why he says its "Reverse Polish Notation, where the operators follow their operands", but then he goes on to show operands following the operators. Am I misunderstanding?
I believe it's actually just "Polish Notation" and not "Reverse Polish Notation" -- can anyone confirm? This point has been confusing me :)
One fairly easy way to get familiar with the notation is to create user-defined filters through the standard Odoo front-end, and you can see what Odoo generates for various combinations of operators and conditions.
Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!
Zarejestruj się| Powiązane posty | Odpowiedzi | Widoki | Czynność | |
|---|---|---|---|---|
|
1
lip 25
|
387 | ||
|
Search a message
Rozwiązane
|
|
1
lut 25
|
1205 | |
|
0
wrz 23
|
2147 | ||
|
2
cze 23
|
3901 | ||
|
1
sie 22
|
12678 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
By default 'search' function takes 'AND' condition between 2 args. You can add 'OR' / 'AND' via '|' / '&' signs.