does anyone know a trick to finding all the saved ...
# general
c
does anyone know a trick to finding all the saved searches that email out? I’m dealing with a company that currently has 6K saved searches and some of them email out but they don’t label their subjects as the saved search title. I need a quick way to find what saved search this email was tied too
p
You can do a saved search, on saved searches. I think you put criteria in for triggered emails = T OR Scheduled = T
🎉 1
c
Okay. I’ll try that.
p
I think that will work, but I haven't tested
c
do you know if there’s a way to pull in the subject of the send email into the search? Like what would that result field be?
p
I don't think that is possible. But I could be wrong.
j
Patrick Olson is correct, it's not possible to pull in the subject/email text. What you can do is run a search on the Sent Email List. Granted this will only be for ones that have actually fired, and I think it only goes back 90 days or so, but at least it's something where you can get the subject and body. PPS, I always copy myself on all saved searches going out (and then filter them out into an archive folder with an email filter) so I can verify if they are actually working on not when someone comes around with an issue. I also always put some text in the body like "For concerns or questions around this search, please contact your NetSuite administrator(s) and reference the "New Account Alert" search." so that when someone shows me the email I know exactly what search to go to.
d
There was a recent article about this, give me a minute to find it
written by Chidi of NetSuite Insights for Salto: Decode NetSuite Saved Search Metadata: The Why and How Read the whole thing, but Chidi specifically mentions your Subject line scenario here. There is a non-metadata method that Chidi mentions which you could also try, from Chloë on NetSuite Insights