Membership Role Criteria Rules to Include an OR statement with AND statements
We're setting up enterprise roles and finding that the following statement works fine
users.Title='Sr Accountant'
and users."Cost Center" like '%1121'
and users."Is Deleted"=0
and users."Is Terminated"=0
However if we have multiple titles in an enterprise role, the following statement doesn't seem to work
users.Title='Sr Accountant' or users.Title='Accountant'
and users."Cost Center" like '%1121'
and users."Is Deleted"=0
and users."Is Terminated"=0
Also tried it formatted as such
users.Title='Sr Accountant'
or users.Title='Accountant'
and users."Cost Center" like '%1121'
and users."Is Deleted"=0
and users."Is Terminated"=0
When processing the rule to add people who are not members, it adds the wrong title and cost center for the last 2 statements.
Version 7.1.1.168724 P04
Perhaps try surrounding them in brackets to make sure the correct conditions are ORed/ANDed (haven't tested it though)?
(users.Title='Sr Accountant'
or users.Title='Accountant')
and users."Cost Center" like '%1121'
and users."Is Deleted"=0
and users."Is Terminated"=0