I have a saved search that looks up sales orders. ...
# general
s
I have a saved search that looks up sales orders. In there, I need it to loop through all sublist item lines and if anywhere on that line, this value is checked, don't return any lines for this sales order on the search. Is that possible with a saved search?
b
You likely need to use summary criteria, with grouping on the internal id or document number
You would probably use SUM on a formula like CASE WHEN {value} = T THEN 1 ELSE 0 END is greater than 0
s
Ok cool! I'm unfamiliar with that area so I'll try that!