We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

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
  • 3,468 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