Hi, In the user setting, I've set up an enum...

security
(Simon Chow) #1

Hi,

In the user setting, I’ve set up an enum list with multiple options that users can chose from, let’s say it’s a country list with (US,Canada, UK) there as an option. And there’s a security filter: [country]=USERSETTINGS(country). But then when people select (US,UK) in the setting, it returns those rows with country that contains both US AND UK at the same time instead of displaying the rows which contains either US OR UK as i intentionally designed. Would there be any solution to this?

Thanks in advance!

Best,

(Aleksi Alkio) #2

You should type IN([country],USERSETTINGS(country)).

(Simon Chow) #3

Thanks again Aleksi, you’ve been super helpful!

(Aleksi Alkio) #4

You’re welcome