Is there a way to use the results of a saved search as criteria for another saved search?
j
Josh Godfrey
07/29/2020, 12:07 AM
@apaule, I guess I'm not sure what you mean by this. Can you explain in a little more detail?
a
apaule
07/29/2020, 6:30 PM
If I a saved search that results in a list of items based on criteria, can I use that result list in another saved search for transactions that contain those items?
👍 1
d
David B
07/29/2020, 10:40 PM
@apaule Unless the first item search is using summaries, you may be able to shoe-horn the first search's criteria into the transaction search
Unless you're doing joins against both the item record and transaction record
David B
07/29/2020, 10:40 PM
may help to post your item criteria
a
apaule
07/29/2020, 10:58 PM
Well I'm tyring to find PO's where line items have a blank Landed Cost Template
d
David B
07/29/2020, 11:40 PM
hmmm, if we're talking about SCM's Landed Cost Template, I have it as a transaction line field (can be added directly to the PO search)
If otherwise, I don't think I'm familiar enough with it to help