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 IT) · 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	4360
Saved Favorite Filters, 'OR' instead of 'AND' filter search and or favorite	0 Jun 24	428
How do I search for products using AND instead of OR? Solved search and or of instead	3 Oct 23	15418
OE7 - product search functionality change from OR to AND product v7 search operation or	3 Feb 23	5703
Attribute list of hide export list, filter list, group by list in fields_get filter export search hide odoo11	1 Jul 22	5415

This question has been flagged

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