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
  • 770 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