D2 - Workflow

 #D2 Workflow Config

#=====================================================

select r_object_id,object_name,associated_dm_process from d2_workflow_config where object_name IN('{workflow_config_name}');

 

#D2 Workflow Report

#=====================================================

select w.r_object_id, w.object_name as task_subject, w.owner_name as user_name, ' ' as task_details, w.tracker_state as task_state, w.start_date as date_sent, w.scheduled_end_date as due_date, 'Workflow' as object_type from d2c_workflow_tracker w where r_object_id in (select distinct w.r_object_id  from dm_relation r, d2c_workflow_tracker w where r.relation_name = 'D2_WF_TRACKER_DOCUMENT' and r.child_id = '<r_object_id>' and r.parent_id = w.r_object_id) order by w.r_creation_date desc