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') ])
Crie uma conta hoje mesmo para aproveitar os recursos exclusivos e interagir com nossa incrível comunidade!
Inscreva-se| Publicações relacionadas | Respostas | Visualizações | Atividade | |
|---|---|---|---|---|
|
Search within a period of date
Resolvido
|
|
22
dez. 23
|
50304 | |
|
8
jul. 24
|
17263 | ||
|
2
mar. 15
|
6557 | ||
|
0
mar. 15
|
9299 | ||
|
1
mar. 15
|
4603 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
