Workflow Queries

SELECT

wi.r_object_id, wi.r_creation_date, wi.r_runtime_state as wi_state,

wf.r_runtime_state as wf_state,

pr.object_name as proc_name,

act.object_name as act_name,

act.subject as act_subject,

wi.r_performer_name as performer,

wf.r_object_id as wf_id,

wf.parent_id

FROM dmi_workitem wi, dm_workflow wf, dm_process (ALL) pr, dm_activity act

WHERE wi.r_workflow_id = wf.r_object_id

AND wf.process_id = pr.r_object_id

AND wi.r_act_def_id = act.r_object_id

AND wi.r_runtime_state <> 2

AND wf.r_runtime_state <> 4

ORDER BY wi.r_creation_date DESC;

AND pr.object_name like 'pvb_da_anders%'

AND wf.r_object_id IN (

  select r_workflow_id from dmi_package pack, dm_sysobject obj

  where any pack.r_component_id = obj.r_object_id

  and obj.object_name ='2013-1334-DEP-01'

)

SELECT

  pr.object_name as proc_name,

  count(*)

FROM dm_workflow wf, dm_process (ALL) pr

WHERE wf.process_id = pr.r_object_id

AND wf.r_runtime_state <> 4

group by pr.object_name

order by 2 DESC

SELECT * FROM dmi_workitem

WHERE r_auto_method_id <> '0000000000000000'

and r_runtime_state = 0

SELECT wi.r_object_id FROM dmi_workitem wi, dm_workflow wf

WHERE wi.r_workflow_id = wf.r_object_id

AND wi.r_auto_method_id != '0000000000000000'

AND wi.r_runtime_state IN(4,5,6)

AND wf.r_runtime_state != '4'