I've tried "+", "|", and "&", but there doesn't seem to be a string concatenation operator to use in the "Additional Search Arguments" field.
In SQL Server it would be CONCAT(first_field, second_field) or first_field + second_field. Is there an equivalent syntax to use for "Additional Search Arguments"?
I can't recall SDM has such function.
You could use the AND for this purpose. For example
((assignee.last_name='Administrator') AND (assignee.first_name='Ada'))
is pretty much like search for assignee who's name is "Administrator, Ada"
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’)
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”