Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
I have 5 search criteria:
A, B, C, D, E
I whant to search (and i have tried diferent options) like in sql: select id from obj_obj where A= 2 and B=3 and C=4 and (D=5 or E=6)
Basic idea is:
- when D is False :
- than look for E = 6
- or when E is False:
- then look for D=5
Numbers are just for example.
I read some documentation and googling but without real success. I tried [('A','=', 2),('B','=', 3),('C','=', 4),'|',('D','=', 5),('E','=', 6)] but the solution is not working. if i try to add () like: [('A','=', 2),('B','=', 3),('C','=', 4),('|',('D','=', 5),('E','=', 6))] i receive and error: ValueError: Invalid term...
Can you please help?
About This Community
This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 7/25/14, 4:32 AM|
|Seen: 1390 times|
|Last updated: 3/16/15, 8:10 AM|