Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

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
  • 1,381 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.