Is it possible to make a save search on a save sea...
# suitescript
d
Is it possible to make a save search on a save search? for example run over bins table and then for each reasult to make search again but without waste units? Its like JOIN but I dont have the table I want to join so I need to make another search
r
There is a Saved Saved Search Search (can't make this stuff up), but probably not what you are after.
m
Try building this as a single SuiteQL query. If you need to do this with saved searches, don't run a separate search for each result. Run the first search, retrieve all results and use that as the criteria for a second combined search of the second table, and then match up the results in your code
👍 1