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.