Odoo Help
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.
Why OpenERP Fail with Postgres DB Filter ?
With OpenERP Framework search method issue.
ids = claim_obj.search(self.cr, self.uid, [('extract(month from cover_date)', '=', month)], context=context)
why extract(month from cover_date) function not evaluated ?
OpenERP Stop to perform this !!!
Serpent Consulting Services Pvt. Ltd.
Serpent Consulting Services Pvt. Ltd. Your Odoo/OpenERP Solution, just an email away!
Zahin,
The domain section is evaluated at ORM and it will not parse any postgresql keywords. What it does it evaluating the OpenERP fields on the left.
I see that you might have misunderstood domain meaning. [('extract(month from cover_date)', '=', month)] is the wrong expression.
The real meaning of the clause(domain) is the first element is field of openerp model, second one is operator and the third one is value you want to operate on.
Hope this helps. Thanks.
OpenERP Does not have smart feature on search. typical to perform complex feature. Where again we have to use traditional cr.execute....
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.
RegisterOdoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.
Test it nowQuestion tools
Stats
| Asked: 9/27/13, 8:28 AM |
| Seen: 923 times |
| Last updated: 3/16/15, 8:10 AM |