- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-10-2024 03:22 AM
I would like to get to how many requests are approved or rejected by each approver who are part of approval assignment group.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-10-2024 05:35 AM
Hi @Mithun Mohan S ,
For sure. Create a report based on the sysapproval_approver and at in below condition:
Only reason that I have created on this month in the condition, is due to limit the amount of records.
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
best regards
Anders
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/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-10-2024 06:05 AM
Good use case for a pivot table (multi level pivot to be precise)
In this case I compared the Approval State against the Approver and the Task Type of what the thing was approving for.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-10-2024 05:35 AM
Hi @Mithun Mohan S ,
For sure. Create a report based on the sysapproval_approver and at in below condition:
Only reason that I have created on this month in the condition, is due to limit the amount of records.
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
best regards
Anders
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/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-11-2024 05:13 AM
Thanks @AndersBGS - Look like your solution is worked.
But will I be able to add additional filter in query for bringing the requests from particular group that are part of approvers.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-11-2024 05:51 AM
Hi @AndersBGS - I'm unable to get complete requests details after I added approver group. Any suggestion that you can provide which would be grateful.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-11-2024 11:17 PM
Hi @Mithun Mohan S ,
What details can't you obtain? All details should be available if you dot-walk in the report from the sysapprover_approval table to the Approving/Approval for.
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
best regards
Anders
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/