Query "Caller" Using email ID

Go to solution
thayanc
Tera Contributor

‎01-03-2024 08:48 AM

I am trying to query the "caller" table using caller's email ID instead of sys_ID.

 

Query using sys_id - working

https://company.service-now.com/nav_to.do?uri=%2Fsys_user.do%3Fsys_id%{{sys_id}}%26sysparm_view%3Des...

 

Query using email - not working

https://company.service-now.com/nav_to.do?uri=%2Fsys_user.do%3Femail%{{email_id}}%26sysparm_view%3De...

 

Please let me know if I could query the Caller table using caller's email.

0 Helpfuls
  • 890 Views
3 ACCEPTED SOLUTIONS

Go to solution
Anurag Tripathi
Mega Patron
Mega Patron
In response to Dr Atul G- LNG

‎01-04-2024 07:50 AM - edited ‎01-04-2024 07:50 AM

This will work

 

https://<instance name>.service-now.com/sys_user.do?sysparm_query=email=<email>

 

 

-Anurag

View solution in original post

Go to solution
Faiz Ahmed Moha
Giga Expert

‎01-04-2024 08:06 AM

Hi @thayanc, 

 

Please try the below sample query.

https://company.service-now.com/sys_user_list.do?sysparm_query=email%3Dabel.tuter@example.com&syspar...

 

Please mark 'helpful' and 'Accept solution' if this works for you.

 

Regards

Faiz Ahmed.

View solution in original post

Go to solution
Dr Atul G- LNG
Tera Patron
Tera Patron
In response to thayanc

‎01-05-2024 05:13 AM

You got answer from expert. 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

View solution in original post

10 REPLIES 10

Go to solution
Faiz Ahmed Moha
Giga Expert

‎01-04-2024 08:06 AM

Hi @thayanc, 

 

Please try the below sample query.

https://company.service-now.com/sys_user_list.do?sysparm_query=email%3Dabel.tuter@example.com&syspar...

 

Please mark 'helpful' and 'Accept solution' if this works for you.

 

Regards

Faiz Ahmed.