Compare two fields

Khanna Ji
Tera Guru

Hi All,

How can I find the records having same data in two fields? For example, if Assigned To and Caller is having same user then I need that data show in the reports.

Can I do this with filter condition?

1 ACCEPTED SOLUTION

The SN Nerd
Giga Sage
Giga Sage

Filter - Assigned to Same As Caller.

find_real_file.png


ServiceNow Nerd
ServiceNow Developer MVP 2020-2022
ServiceNow Community MVP 2019-2022

View solution in original post

3 REPLIES 3

The SN Nerd
Giga Sage
Giga Sage

Filter - Assigned to Same As Caller.

find_real_file.png


ServiceNow Nerd
ServiceNow Developer MVP 2020-2022
ServiceNow Community MVP 2019-2022

Boyan1
Kilo Sage

Hello, 

Actually in the filter condition you have an operator 'Same As'

find_real_file.png

 

Best regards,

Boyan

christopher cre
Kilo Guru

Hi,

 

You can build a report and use the condition "is same as"

find_real_file.png

 

Best regards