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?
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:
If you truly only want the RITM approvers, the Where clause on 300 can just be:
app_sysapproval=ritm_sys_idbut 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
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:
If you truly only want the RITM approvers, the Where clause on 300 can just be:
app_sysapproval=ritm_sys_idbut 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
