Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to report with 'is one of' when the strings contains comma (Like: firstName, lastName)?

davidk90
Kilo Contributor

Hello,

Can anyone suggest a solution to my problem?


I want to create a report from sys_history_line_list.do to the "New" field for user names.

But because user names contains comma, the 'is one of' filter splits every name into two lines which gives back 0 results.

Thanks a lot for your tips in advance!

Regards,

David

5 REPLIES 5

Sugarthan
Tera Contributor

I too experience a similar problem, when querying using a list of Customer Names that may contain commas. Probably the "is one of" filter should have considered the Line Feed Character (Line Separator Character) instead of Commas.