AnsweredAssumed Answered

How do I concatenate fields in "Additional Search Arguments?  For an example, I want all records where assignee.last_name concatenated with assignee.first_name = 'FIRSTLAST' (yes, there are better ways of this specific inquiry, but it's the technique I'm

Question asked by Michael_BCBST on Oct 24, 2018
Latest reply on Oct 25, 2018 by Michael_BCBST

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"?

Attachments

Outcomes