Trying to use application studio to filter a combo box that is being used to get the list of Sales Persons. I want to filter that list by at least 3 Roles how do i do that in applications studio here is what i have tried and it does not seem to work.
Looks like you’ve used syntax for IN rather than =
Try something like
RoleCode = 'Role1' AND RoleCode = 'Role2'
or try…
RoleCode IN ('Role1','Role2')
I haven’t tested this syntax so don’t bet your bottom dollar.
This is what i ended up using and it seems to be working
RoleCode = ‘FieldSalesManager’ OR RoleCode = ‘FieldSalesperson’