How do you search invoice data with an 'OR' condition?

Question

I'm trying to search through my invoices and what I want to search by is the equivalent of:
Invoices that are:
on or after the self.start_date AND
on or before the self.end_date AND
type = out_invoice OR out_refund
I can't quite get the syntax right with the leafs.  I've tried various combinations such as:
self.env['account.invoice'].search([('date_invoice','>=',self.start_date),('date_invoice','<=',self.end_date),('type','=','out_invoice'),'|',('type','=','out_refund')]) What's the proper synta

Niyas Raphy (Walnut Software Solutions) · Accepted Answer

Hi,
You can try this,

self.env['account.invoice'].search([('type','in',['out_invoice', 'out_refund']), '|', ('date_invoice','>=',self.start_date),('date_invoice','<=',self.end_date)]) Thanks

Related Posts	Replies	Views
Android: How can I filter my search using (a OR b) AND c ? search and or android	0 Mar 15	5755
How do I search for products using AND instead of OR? Solved search and or of instead	3 Mar 25	19483
Saved Favorite Filters, 'OR' instead of 'AND' filter search and or favorite	0 Jun 24	2380
OE7 - product search functionality change from OR to AND product v7 search operation or	3 Feb 23	7212
Attribute list of hide export list, filter list, group by list in fields_get filter export search hide odoo11	1 Jul 22	7105

This question has been flagged

Enjoying the discussion? Don't just read, join in!