Hi, I have a question to “security filters”. Assume I have a table with a column useremail which is used in the security filter [useremail]=USEREMAIL().
Is my understanding correct that the columns used in the condition of the security filter must be a key or a part of the key of the table? So my key in the table must always include the email?
Otherwise it could happen that an already existing record of another useremail will be overwritten with my content. This might happen if I select a key already existing for the other email.
Is this intentional?
I am asking because in my view it is very complex to always work with combined kyes.