Se rendre au contenu
Menu
Cette question a été signalée
1 Répondre
4010 Vues

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 !!!

Avatar
Ignorer
Meilleure réponse

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.

Avatar
Ignorer
Auteur

OpenERP Does not have smart feature on search. typical to perform complex feature. Where again we have to use traditional cr.execute....

Publications associées Réponses Vues Activité
2
oct. 23
1522
0
oct. 21
1738
0
août 15
2920
3
juin 15
7847
1
mars 15
5365