Hi All. Saved Search Question: What's the best way to include a list of values as criteria for the search. For example, I want all sales orders where the customer is from one city in a list of cities?

you can use billing or shipping address city as criteria if that is what you are looking for.

@Suitestallion thanks. I know how or what fields i'm interested in. What i don't know is how to use a list for criteria. For example, if you look at this screenshot. I don't know how to include more than one value for my criteria (such as a list of cities). When i save this, it just includes "Sarasota". Thanks!

hmm, how many cities do you want to see? I don't know if there is any easy way, I just do it for each one, if it's not more than 4 or 5

that's what i was afraid of. I got a user request for 16 cities. I've run into this problem in the past and brute forced it like you. what i really want is a sql "in" function.

I see 2 ways… 1. Use a formula with a case when OR functionality and list all the cities out. 2. Use expressions in your criteria and add a new line for each city. Be sure to use Parens around the city lines and OR between each city.

thanks @Rebecca option one seems to work, but is tedious. I'd like to try #2, but i'm not sure about how the syntax would look like. Do you happen to have an example or pointer to where i can find more about expression syntax? thanks

SuiteAnswer article 8447 covers using expressions

Thanks @Rebecca! I used #2. couldn't get the case statement to work.