Report to show all Approvals on changes, but only on changes that a Specific Group are an approver

Rob Lenihan
Tera Contributor

‎05-22-2020 06:57 AM

Hi, 

Is it possible to create a report, where the criteria is that it will show all approvals for all change records that a specific approval group are approvers on? 

So - change record has an approver group "APPROVER-A" on it. The report criteria would be that it shows all change records that this team has to approve; however, it would also show all the approvers on those change - not just APPROVER-A. 

I can create a report that shows all approvers on the changes (and i group by changes to see the # of approvers).I also can also create the report that shows all the changes that "APPROVER-A" are an approver on.  But, I can't get a report to show this information together. As soon as I set the criteria to have the specific approver group, it removes all the other approval groups. I've tried the sysapproval_group table, but I think this must not be the right way to go, because I can't specific a group, and still show all other groups too.  

Thanks for your time. 

Rob

Labels:
0 Helpfuls
  • 2,386 Views
2 REPLIES 2

Joaquin Campos
Mega Sage

‎05-22-2020 08:57 AM

Hi Rob,

Is this what you're looking for?

In this case I'm filtering on specific approvals assigned to group SG_IT_Change_Managers.

Hope it helps!

 

Joaquín

find_real_file.png

Preview file
122 KB
0 Helpfuls

Rob Lenihan
Tera Contributor

‎05-22-2020 10:51 AM

Hi Joaquín, thank you for replying.

I need a bit more complicated though.

So, in the report, I would need to see all approval records for the changes; not just SG_IT_Change_Managers.. but, i only want to see the changes that SG_IT_Change_Managers are on.

 

So, example, 10 changes, each change has 6 approvers on it. 7 of those 10 change records, , SG_IT_Change_Managers is an approver on.

 

Ideally, the report would show me rows of data, i'm assuming 1 row per approver per change. I would group it 'by change record number". So, of the 10 change records in the system, I would only see 7 (since SG_IT_Change_Managers is only on 7 of them), and beside each change record, it would show the number in brackets of how many approvers outstanding on the change). 

CHG003342 (6)

CHG003347 (4)  (because 2 may have already approved)

CHG003372 (2)  (because 4 may have already approved)

 

Does this make sense? 

0 Helpfuls