Hey All. Wondering if anyone knows of a saved sear...
# general
e
Hey All. Wondering if anyone knows of a saved search that can be used to show Purchase Orders that have not been emailed to vendors. My first thought was to create a Purchase Order search that excludes those that have have an associated message that contains an attachment. I created the following search but I am still getting POs in my results that contain messages with attachments:
m
it is possible that some POs have multiple emails sent with and without attachments
e
@Marc yes, that seems to be the issue. The saved search won't exclude the PO if it has other emails that do not contain attachments.
m
Maybe with formula like case when If the record contains file attachement and message without file attachement or record contains file attachement then 1 else 0 end In criteria you select only 0 Something like this
You need to try with message search