Report: SCTASKs where RITM Approver is a specific user

Jon Collins2
Kilo Sage

Hi Folks, 

I am trying to build a report that displays SCTASKs, where RITM approver was one of a couple specific users, and the SCTASK is a specific assignment group. This seems like it should be a simple report, but I cannot figure it out.  

I built this, and it's displaying a handful of SCTASKs , but I've confirmed, there are hundreds of SCTASKs that should meet this criteria. Any idea on what I did wrong?

 

JonCollins2_0-1701369062408.png

1 ACCEPTED SOLUTION

Brad Bowman
Kilo Patron
Kilo Patron

Hi Jon,

Your report is showing you the SCTASKs where the SCTASK approver was one of those specific users, etc.  Unless I'm over-thinking/complicating this, what you need to do is create a Database View to join the RITM, SCTASK, and Approval tables, then create your report using the Database View Name as the Table to apply your approver and assignment group criteria at the Conditions level, not the Related List Conditions.  The Database view would look like this:

BradBowman_0-1701372569578.png

If you truly only want the RITM approvers, the Where clause on 300 can just be:

app_sysapproval=ritm_sys_id

but to get the RITM approvers plus the handful of SCTASK approvers, use the Where clause:

app_sysapproval=ritm_sys_id||app_sysapproval=sctask_sys_id

 

View solution in original post

3 REPLIES 3

Brad Bowman
Kilo Patron
Kilo Patron

Hi Jon,

Your report is showing you the SCTASKs where the SCTASK approver was one of those specific users, etc.  Unless I'm over-thinking/complicating this, what you need to do is create a Database View to join the RITM, SCTASK, and Approval tables, then create your report using the Database View Name as the Table to apply your approver and assignment group criteria at the Conditions level, not the Related List Conditions.  The Database view would look like this:

BradBowman_0-1701372569578.png

If you truly only want the RITM approvers, the Where clause on 300 can just be:

app_sysapproval=ritm_sys_id

but to get the RITM approvers plus the handful of SCTASK approvers, use the Where clause:

app_sysapproval=ritm_sys_id||app_sysapproval=sctask_sys_id

 

Thanks Brad! This is exactly what was needed.

You are welcome!