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.
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
Search a message
Solved
|
|
1
Feb 25
|
541 | |
|
0
Sep 23
|
1592 | ||
|
2
Jun 23
|
3257 | ||
|
1
Aug 22
|
11861 | ||
|
7
Oct 20
|
9619 |
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.