how to get report on all the catalog items and its respective approvers, approver groups

Gaddam Sai Srut
Tera Contributor

I want to create report on all catalog items and respective approvers for the catalog items. Can anyone help me out with this? 

1 REPLY 1

Mohith Devatte
Tera Sage
Tera Sage

Hello,

You can configure the report on "sysapproval_approver" table and keep the condition for report as source table is "sc_req_item" and if you want to do group by approver in group by column select group by approver and run the report .  You can select type of report as bar graph.

please see the attachment attached for clarification.

This is for getting only approvers report. But if you want to do for groups as well create another report on the same table with the same mentioned condition above  and do group by "Group field" and type as bar and run the report. You can see multiple bars and they are divided by groups 

please mark this helpful if you find it useful.

 

Thanks ,

Mohith Devatte.