How to use method search to get the ids from a date interval?

Question

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

Bole · Accepted Answer

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','='

Rachid · Answer

use this:

invoice_obj.search(cr, uid,['&','&','&',('date_invoice', '>=', date_from ),('date_invoice', '<=', date_to),('type','in', ['in_refund']),('state','=','paid') ])

相关帖文	回复	查看
Search within a period of date 已解决 filter date v7 search	22 12月 23	49333
How to search for several words in products name from sales order? 已解决 v7 search	8 7月 24	16240
How can I locate the certain SO/PO with the product code/desc? v7 search	2 3月 15	5654
How to allow the use of the child_of operator for users ? v7 search	0 3月 15	8344
Once installed, how do you use addon web_filter_and_condition? v7 search	1 3月 15	3800

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！