Sub-flow related reporting

[ashwinipingle]

Hello Flow experts, 

We are using Xanadu patch 7a

We have designed a sub-flow in Flow designer, which asks for approval step by step starting with project manager, then with CIO, COO and CEO in that order. The Action is standard "Ask for Approval" for each of these approvals.

I need to now create a dashboard or a report which shows the flow executions which are active (in progress workflows) and the following information

• flow name - this will be the specific sub-flow which we have created
• pm_project name - the flow is for approval of the pm_project (part of strategic portfolio management) so the name and number of the project 
• Approval Step Name - the specific "Ask for Approval" e.g. CIO Approval, COO Approval etc. This is annotation for each of the approval step
• Approval Pending with user - the approver/s with whom this is pending
• Approval pending since date - this could be calculation from the date the Ask for Approval step was active for the current approval step to sysdate

Thus a program manager can get to see the list of all active flow executions (for this specific sub-flow) and find with which approver the flow is waiting for approval.

I did not find all the required data in sys_flow_context table. Any help on how to achieve this?

[Uncle Rob]

Why wouldn't you report on the Approvals themselves instead of the flow contexts?

[ashwinipingle]

Hello @Uncle Rob , 

Thanks for your response. I do get the project number and name and user and date however I do not get the flow name/sys_id nor do I get the exact approval step name annotation text e.g. COO Approval or CIO approval.

Best Regards,

Ashwini Pingle