I agree AND will work in the case of a single case; it breaks down when you have several ordered pairs though:
Concat(assignee.last_name,assignee.first_name) in (‘Last1First1’,’Last2First2’,’Last3First3’)
vs
assignee.last_name in (‘Last1’,’Last2’,’Last3’) AND assignee.first_name in (‘First1’,’First2’,’First3’).
After some more digging, it appears you are correct – SDM doesn’t have the capability. Luckily, in most cases one can dig up a single ID field to encompass both criteria (assignee.userID in this case), and bypass the issue. I was just hoping concatenation was an option. I did find an excellent overview in the Technical Reference section of the documentation, under “Where Clauses”