Running a Report for Approval Requests

BH14
Tera Contributor

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!

1 ACCEPTED SOLUTION

Dr Atul G- LNG
Tera Patron
Tera Patron

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

Dr Atul G- LNG
Tera Patron
Tera Patron

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]

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