Hi there,
I need to the use some kind of wildcard for certain users in record level security
I am using both the user/password method (login page) and the user id methods (record filtering per user table). The user table Looks like this:
column1 -> user_id
column2 -> password
cloumn3 -> department
user_id field + password field are used for the login page.
department field is used for the record level security.
My question: is it possible to use the department field with a wildcard (%)? Literally entering a % int the user table doesn't work. Neither does it work to simply set the operator in field settings of the department field in the user table to "like".
Thanks!