Odoo Help


How to search in an object depending if one field many2many that is empty?

Anabela Damas
on 5/20/14, 4:59 AM 1,971 views


I'm trying to get the id's of the invoices that don't have payments. 

I've try like this: 

invoice_ids = invoice_obj.search(self.cr, self.uid, [('payment_ids','!=',[])])

And I get this WARNING/ERROR:

2014-05-20 08:17:54,280 10010 WARNING db openerp.osv.expression: The domain term '('payment_ids', '!=', [])' should use the 'in' or 'not in' operator.
2014-05-20 08:17:54,280 10010 ERROR db openerp.osv.expression: The field 'Payments' (payment_ids) can not be searched: non-stored function field without fnct_search

And it returns all of the invoices. 

If I try like this: invoice_ids = invoice_obj.search(self.cr, self.uid, [('payment_ids','!=',False)]) the warning disapears but the error is the same and it returns all of the invoices.

So, how do I get the invoices that have been paid and partially paid ? 



Sajad KK
On 5/20/14, 5:04 AM


invoice_ids = invoice_obj.search(self.cr, self.uid, [('payment_ids','!=',False)])

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.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 5/20/14, 4:59 AM
Seen: 1971 times
Last updated: 3/16/15, 8:10 AM