Report for sys_flow_context

[SubasishT]

I need to generate a report of all flow executions from sys_flow_context with every state (complete/failed/etc)

Example 

Flow A - Completed 

Flow B - Compeleted

Flow A - Failed

So, for flow A , it should have count 1 for completed and 1 for failed

similarly for every flow along with respective state it should show the count

please help me to do the flow

i tried to do via reports but the image is coming blurry

[Amit Verma]

Hi @SubasishT 

Have you added sys_flow_context table to glide.ui.permitted_tables system property ? This will enable you to create report on this table as it is a system table. Once done, you can create the report as below :

Please give this a try and let me know the results.

Thanks & Regards

Amit Verma

[SubasishT]

I tried this but the report was blurry ! I wanted to have this report through a flow where it ca. give distinct name with respective states

[SubasishT]

I want to do it in flow

[Amit Verma]

Why you want to fetch this report via flow ? Do you want to send this report on scheduled basis ? If yes, then you can schedule a report as well. Also, are you extracting the reports in the form of PDF and that is coming out blurry ? Can you please share some screenshots ?