Joseph,
The Workflow Map has a different set of tables for the activities and templates. I am not sure whether you wish to map each activity from the workflow to the workflow map, or if you just want to return the template data used for that particular workflow map, so I am not sure how to correctly update your query as shown.
If you simply want the workflow map data, you only need to change the following table names:
- [WORKFLOW_PROCESS_ACTIVITY] -> [WORKFLOW_MAP_ACTIVITY]
- [ACTIVITY] -> [ACTIVITY_TEMPLATE]
- [ACTIVITY_ASSIGNMENT] -> [ACTIVITY_TEMPLATE_ASSIGNMENT]
And you will also need to change the join clause from C.ID = E.SOURCE_ID to D.ID = E.SOURCE_ID.
If you are hoping to connect activity data between the two, unfortunately, Innovator does not give a direct method of connecting the ACTIVITY_TEMPLATE with the resulting ACTIVITY. This means that you will need to join only on the name of both of those items, and if there are multiple activity templates with the same name, or you rename the activity in the map, you will not be able to connect those with 100% accuracy.
I hope this helps.
