Hi,

I am trying to figure out a way to create a saved search that will show only orders that have one or many 'license' line items but that do not also have a 'maintenance' line item (therefore, I want a search to find "license only" sales orders).

We have a custom field on all our items that would indicate if the item itself is license vs maintenance, but I can't figure out a way to use this attribute to limit my saved search. If I include this field as a criteria for my search and set the value to show "None Of = Maintenance", my results don't include maintenance lines but the other lines of the order that include maintenance would show up. I want the whole order excluded from my results if any one line includes an item that has the attribute = maintenance.