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!
Howdy, Stranger!
Categories
- 4.5K All Categories
- 86 General
- 13 Training
- 212 Installation / Setup
- 1.2K Flows
- 112 Rules
- 277 Administration
- 215 Portal
- 502 General Q & A
- 721 Forms
- 355 Reports
- 3 Designer Extensions
- 47 Example Flows
- 58 CSS Examples
- 1 Diagram Tile
- 8 Javascript Controls
- 189 Pages
- 5 Process Mining
- New Features
- 187 Datastructures
- 72 Repository
- 237 Integrations
- 30 Multi-Tenant
- 27 SDK
- 81 Modules
- 60 Settings
- 26 Active Directory
- 12 Version 7
- 36 Version 8
- 143 Lunch And Learn Questions