We are transitioning to Workflow Manager for Server. Since there is no reports functionality as in classic we are not sure how to access the data to prepared and show information using dashboards, especially in real time. How to include extended properties data and other information from the workflow service so it can be use in dashboards???
When you create a workflow item in the portal, 1 hosted feature service and 2 views (from said hosted feature service) are created. Within these portal items are a collection of layers and tables that contain a good majority of information about your workflow item and jobs (to include extended property tables). You will need to look at the "jobExtPropertyTableDefinition" table within the main service to identify what additional tables are "extended property tables" as they are labeled under their table id and not the table alias.
