Simple list report

Shawn34 · ‎02-21-2025

On the sysapproval_approver table, how would you show the managers direct reports and the completed approvals? I'm missing something in my query not sure what exactly.

AndersBGS · ‎02-21-2025

Hi @Shawn34 ,

What do you mean? Do you want to show the approvals in a report for specific approvers manager or?

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Voona Rohila · ‎02-21-2025

Hi @Shawn34

Can you share the filter you tried?

Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for
Kind Regards,
Rohila V
2022-25 ServiceNow Community MVP

Dr Atul G- LNG · ‎02-21-2025

Hi @Shawn34

Look like you are mixing 2 different side, please provide clear details.

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

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