Current Workflow Step

x-unileveruser11_-_(deleted)

Dear All, I've got the following query which gives me the active step for a workflow with no subworkflows, can anyone give me a hand so that it covers any subworkflows as well ?

Victoria_Freihofer_(rgsinc01admin_-_(deleted))

This query displays active workflows from selected maps with all current steps, including subflows. SELECT subwork_title "TITLE", TO_CHAR(work_dateinitiated , 'MM/DD/YYYY') "INITIATED", subworktask_title "TASK NAME", TO_CHAR(subworktask_dateready, 'MM/DD/YYYY') "DATE RECEIVED", TO_CHAR(subworktask_DateDue_Max, 'MM/DD/YYYY') "DUE DATE", DECODE ((SELECT '*' FROM WWork w1 WHERE WSubWorkTask.SubWorkTask_DateDue_Max < SYSDATE AND w1.Work_WorkID = WWork.Work_WorkID), '*', 'Overdue', NULL, ' ') AS "LATE", DECODE(kuaf.type, 0, kuaf.lastname || ', ' || kuaf.firstname, 1, kuaf.name) "PERFORMER NAME", DECODE(work_status,2,'Executing',1,'Suspended',-2,'Stopped') "WORKFLOW STATUS", DECODE(subworktask_status,-1,'Done',2,'Ready',3,'Started',4,'Suspended',5,'Executing') "TASK STATUS", FROM wwork, kuaf, wsubworktask, wworkaudit, wsubwork, dtree, wmap WHERE (dtree.dataid=wmap.map_mapobjid) AND dataid IN('977166', '977341', '1867754', '1255850', '1257044', '2585978') AND subwork_mapid=map_mapid AND kuaf.id=subworktask_performerid AND subworktask_workid=work_workid AND work_workid=workaudit_workid AND work_workid=subwork_workid AND (subworktask_status=-1 or subworktask_status=2 or subworktask_status=3 or subworktask_status=4 or subworktask_status=5) AND workaudit_status=1 AND NOT work_status=-3 AND NOT subworktask_status=1