Enabling Business Process Reporting
By default, this feature is disabled. To enable it, you must first enable it globally and then enable it individually for each tenant where you want to collect the corresponding data.
To enable this feature globally, set the EnableBatchRoutingStatistic field to true in the dbo.Settings database table.
To enable data collection for a specific tenant, set the third bit in the Flags field in the dbo.Tenant table. To enable data collection for all tenants in MS SQL, use the following command:
SQL Update Tenant set Flags = Flags | 4
Please note that there are other features that can be enabled using the Flags field in the dbo.Tenant table. The following is a sample command that demonstrates how the several features could be enabled at once in MS SQL:
Update Tenant set Flags = Flags | 4 | 2 | 1
If the Business Process Reporting feature is enabled, changes made at each stage for every batch in the tenant are recorded in the dbo.BatchRouting table, with the current batch states reflected in the dbo.BatchState table.
4/12/2024 6:16:02 PM