The use case for this is the customer wants to see an audit trail of the workflow in the dashboard. The details like creator, updater, workflow task, entity details need to be displayed in the dashboard.

The workflow tasks is captured in the backend in multiple like

  1. mta_wfi_event - This table keeps track of all the events of the workflow like ‘event comment’ , ‘Approver’ , ‘Taskname’ etc
  2. mta_wflow_task - This table provides the granular details like ‘name’ - > workflow task , ‘approver’ etc

In the dashboard under the query section execute the following SQL query

select IL.creator,

       IL.credate,

       IL.updator,

       IL.upddate, 

       WE.task_name as WorkFlowTask,

       WE.event_comment as EventComments,

       IL.LOADID, ME.name as EntityName   

from semarchy_repository.mta_wflow_task WT, 

semarchy_repository.mta_entity ME , 

semarchy_repository.mta_integ_load IL, 

semarchy_repository.mta_wfi_event WE

where WE.O_WF_INSTANCE = IL.UUID and WE.EVENT_TYPE = 'TRANSITION' 

and IL.STATUS = 'FINISHED'and WT.name = WE.task_name

The following screenshot displays query result on a sample entity.


How to create a dashboard with workflow audit trail?