Filter data with Enum list in User settings

[Gaxer]

I would like to find a more efficient way for the users can filter different categories in a table from user settings. I use a security filter that works but my plan “Publisher PRO” doesn’t allow it.

My security filter in my table “News” was <<IN (([Subtitulo]), Usersettings(News))>>

I cant create a slice because is an enum list with 9 different options and create a slice for each combination of options is impossible.

[Steve · Accepted solution]

Gaxer:

My security filter in my table “News” was <<IN (([Subtitulo]), Usersettings(News))>>

That expression is in template format, which is not valid outside of templates.

Gaxer:

I cant create a slice because is an enum list with 9 different options and create a slice for each combination of options is impossible.

A slice–one slice–is exactly the way to go. If you have a working security filter expression, just move that expression to the row filter expression of a slice.

[Gaxer]

Thank you it works