hi everyone, i bit stuck…. i have a scripted saved search exported from UI, i have a summary of 1s and 0s, but in UI i can’t limit the results for some reason. so I’m looking into doing it in a script for WF action script
basically value I need for my workflow is custom record PARENT ID, but my filters are based on its child record sublist which the search is based on. I can properly get the values I need and create a formula that would give me 1s for False and 0 for True — this is a boolean flag on the sublist. However since the search is build upon the CHILD record, the results would show up like this
ex
record 1 has 2 Ts and 1 F = do not show
record 2 has 1 T and no F = show
how do I go about this? is it possible in a script to push a filter wherein I filter the results of the existing search and then exclude from results if there is one or more occurrence of 1(False)?