Requirement – In the saved search, the purchase order records need to be excluded if any of its line items satisfies a condition. When adding the condition, only the item line is excluded from the search, not the record.
Solution – The condition should be applied as the summary condition.
CASE WHEN item.class =’labor’ THEN 1 ELSE 0 END
Equal to 0
Summary – Maximum