Running a Report for Approval Requests

Go to solution
BH14
Tera Contributor

‎06-17-2024 01:26 PM

Hello Community - I'm stuck on a report that I'm trying to run. 

I need to run a report that shows Approvals that exceed a certain amount of time (in this case 48 hours [if feasible in business days]) after the approval is created. 

I was thinking I would need to run a Single Score report that references the sysapproval_approver table, but I'm not sure how to configure the report from there. 

Do I use Report > Chart Colors?

Just looking for a little direction and help. 

 

Thank you all in advance!

0 Helpfuls
  • 565 Views
1 ACCEPTED SOLUTION

Go to solution
Dr Atul G- LNG
Tera Patron
Tera Patron

‎06-17-2024 02:05 PM

Hi @BH14 

 

Unfortunately, there is no field on sys_approval table which indicates that approval passed more than 48 hrs. For that you can use created date when the approval created but there is no field  which capture when it approved that get captured in Updated field.

 

and you can get the difference of both and then make a report.  

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

1 REPLY 1

Go to solution
Dr Atul G- LNG
Tera Patron
Tera Patron

‎06-17-2024 02:05 PM

Hi @BH14 

 

Unfortunately, there is no field on sys_approval table which indicates that approval passed more than 48 hrs. For that you can use created date when the approval created but there is no field  which capture when it approved that get captured in Updated field.

 

and you can get the difference of both and then make a report.  

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

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