Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Get RITM details in the report

Lucky1
Tera Guru

‎01-16-2024 05:02 AM

Hi all,

 

I have created a report on Approvals table, with the below filter condition

Approval for starts with RITM

 

Now I want to choose the columns : Approver, Approval for, Requested by, Requested for and the Request number.

 

 

But currently unable to choose columns of Requested by , Requested for and Request number.

 

Can someone please help me on this?

 

 

Regards,

Lucky

0 Helpfuls
  • 884 Views
5 REPLIES 5

Dr Atul G- LNG
Tera Patron
Tera Patron

‎01-16-2024 05:21 AM

Hi @Lucky1 

You need to create Data base view to bring these fields together. As approval table did not hold any other attribute of REQ/ RITM

*************************************************************************************************************
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]

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

Lucky1
Tera Guru
In response to Dr Atul G- LNG

‎01-16-2024 05:46 AM

Hello Atul,

 

I have created a database view like this, but here the columns Requested for and Opened by are showing the same.

To check, when I open the record and checked, the Requested for is different.

 

Please help.

 

 

Regards,

Lucky

0 Helpfuls

Dr Atul G- LNG
Tera Patron
Tera Patron
In response to Lucky1

‎01-16-2024 05:48 AM

Screen shot missing mate. 

*************************************************************************************************************
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]

****************************************************************************************************************
0 Helpfuls

Lucky1
Tera Guru
In response to Dr Atul G- LNG

‎01-16-2024 06:12 AM

Sorry. Forgor to paste 🙂

 

Lucky1_0-1705414317234.png

 

0 Helpfuls