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

[davidk90]

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

[Michael Fry1]

Can't you just use full name without comma:

[davidk90]

No, I can't.
Because the New value contains the comma, so if I search for the string without the comma it's not give me any response.

These are names written like last, first name (USER ID)

[Dave Smith1]

It sounds like you're searching against the "Full Name" rather than "First Name" or "Last Name" - the "Full Name" is simply an amalgamation of those two fields.

[davidk90]

But in the "New" field of .service-now.com/sys_history_line_list.do? this is how the pparameters look like. I think I can only filter on this. Or I should be able to filter only the   Last name, even if there is no option for this? There are no such columns.