Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Hi,
I need to get the ids of the invoices between an interval with the start date and end date inclusive, and from this just the invoices in state paid , and type in_refund ?
I've like this :
invoice_obj.search(cr, uid,[('date_invoice', '>=', date_from ),('date_invoice', '<=', date_to),('type','in', ['in_refund']),('state','=','paid') ])
But the result isn't the expected.
What is the way to do it?
Thanks
Serach method are using polish notation . basicly when you do some_obj.search(cr, uid, [ XXXX ])
Now.. [ XXX] can contain only one comparation.. like [ ('date_invoice','>=', date_from )] .. that is easy...
If more then one comparation tuple is needed, then you need to put extra logical operators wich are: '|' = OR, '&' = AND ...
In your case, i would write search like this:
['&','&','&',('date_invoice', '>=', date_from ),('date_invoice', '<=', date_to),('type','in', ['in_refund']),('state','=','paid') ]
in order to serach for records that sattisfy ALL condition tuples, the way you wrote it will be interpreted as:
[('date_invoice', '>=', date_from ) OR ('date_invoice', '<=', date_to) OR ('type','in', ['in_refund']) OR ('state','=','paid') ]
I hope this will help a bit
use this:
invoice_obj.search(cr, uid,['&','&','&',('date_invoice', '>=', date_from ),('date_invoice', '<=', date_to),('type','in', ['in_refund']),('state','=','paid') ])
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
