How to report with 'is one of' when the strings contains comma (Like: firstName, lastName)?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-01-2017 07:39 AM
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
Labels:
- Labels:
-
Reporting
- 1,897 Views
5 REPLIES 5
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-17-2024 05:31 AM
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.