Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

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

paulmorris
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

paulmorris
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
Mega Guru

Hi,

 

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

find_real_file.png

 

Best regards