I was wondering about a way to use filters in an “additive manner” or boolean AND. I have a report for Sales Order, where I wish to show only those Sales Orders which contain 3 specific Item Names in the Sales Order Item table.
When you select the first Item Name to filter, the list is adequately reduced.
When you add a second filter for Item Name, the list comes out empty.
I would like to be able to specify the conditions for each filter, so that I can filter by Sales Order WHERE Item Name LIKE “Banana” AND Item Name LIKE “Strawberry”, with the expected result showing only those sales orders where “Banana” and “Strawberry” where BOTH included.
How to do this?
Or is this a new feature we should program into the filter system?