AnsweredAssumed Answered

Membership Role Criteria Rules to Include an OR statement with AND statements

Question asked by Mike Calaway on Feb 28, 2020
Latest reply on Feb 28, 2020 by Mike Calaway

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

Outcomes