I need to only display information for records inc...
# suiteanalytics
m
I need to only display information for records included on a 100+ Internal ID's I have. I have them on a comma separated list. • How do I do this on a Saved Search? • Any suggestions about the formula or SQL expression I should use?
s
Do a Formula (Numeric) criteria, with a formula like this:
CASE WHEN {id} IN (123, 456, 789) THEN 1 ELSE 0 END
putting your comma separated list inside the parentheses instead, then set the criteria for equal to 1
m
OMG I have a lot to learn. I didn't know it was that easy. Definitely need to learn some SQL. Thank you