I try to use the following expression as a security filter or as a row condition in a slice but the result is not what I would expect. I want the user (identified by his email) to be able to see only the data of the remaining members of the same Coro (Choir) than him. Why a randomly chosen value from the list? The email is the key value of table Miembros and it should identify uniquely the user if he is in that table and therefore, tell us his choir to compare with the choir of every row and only show the user the rows with his same choir. What am I doing wrong?
(The value of column ‘Coro’) is equal to (One randomly chosen value from this list (
…The list of values of column ‘Coro’
…from rows of table ‘Miembros’
…where this condition is true: ((The value of column ‘Email’) is equal to (USEREMAIL()))))