IN() doesn’t work when looking at a column that is an enumlist? I had assumed that calling an entire column of enumlist would make the list like one big join… But it doesn’t work. Am I seeing a bug by design, what’s my options?
Example: table PEOPLE with column [people_uid] (I create a slice for this table to parse it down to just the logged in user, it’s called PEOPLE_THISUSER… I use [people_useremail]=USEREMAIL()… there is also a table PROJECT with enumlist column [project_users]. I’ve got an action that adds [people_uid] concatenate to a list ", " of allowed users for this project. So, in the PROJECT table security filter I want to say… IN(ANY(PEOPLE_THISUSER[people_uid]), [project_users])
But it doesn’t work!?