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 !!!
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
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 !!!
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....
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign upRelated Posts | Replies | Views | Activity | |
---|---|---|---|---|
|
2
Oct 23
|
1488 | ||
|
0
Oct 21
|
1696 | ||
|
0
Aug 15
|
2881 | ||
|
3
Jun 15
|
7790 | ||
|
1
Mar 15
|
5304 |