How is the Flow Structure Report generated, and what tables can I query for custom error dashboards

I’m using the Flow Structure Report in Decisions and would like to expand on its data for a custom error dashboard, possibly integrating it with our own error handling. I’m comfortable with SQL and would like to know what tables or sources the Flow Structure Report uses, and if there are other tables I can query for more detailed tracking. Any guidance or documentation would be appreciated.

Comments

  • Hello,


    The Flow Structure Report pulls data from several Decisions system tables. While you can’t directly query the report’s internal logic, you can access related data from these tables for custom reporting and error tracking: (At time of writing)


    dbo.element_registration

    dbo.flow_state_storage_data

    dbo.flow_execution_record

    dbo.execution_record

    dbo.entity_assignment

    dbo.flow_state_storage

    dbo.assignment_handler_data

    dbo.flow_data_delta_storage

    dbo.entity_header_data

    For more details on Decisions database tables, see:  

    Assignment Database Tables - https://documentation.decisions.com/docs/assignment-database-tables

    This should help you build a more comprehensive error dashboard by combining Decisions data with your external sources. Hope this helps!

Sign In or Register to comment.