bobby_tamayo_automic

How to get the WorkFlow name given a task name ?

Discussion created by bobby_tamayo_automic on Dec 28, 2016
How to get the WorkFlow name given a task name . In this case, we are looking for the WorkFlow in which a task TESTBTA is used within that WorkFlow.

select  OH_Name as WorkFlow from OH jobp
where OH_Otype = 'JOBP'
and OH_DeleteFlag=0
and Oh_Client=1
and jobp.OH_Idnr in (
                select  wrkflw.JPP_OH_Idnr from JPP wrkflw
                             inner join OH jobs on wrkflw.JPP_Object=jobs.OH_Name
                               and jobs.OH_Name='TESTBTA'
                               and jobp.OH_Client=jobs.OH_Client
                               and jobs.OH_DeleteFlag=0);


Sample output:

WorkFlow
---------------
JOBPWGT
JOBP.NEW.2

Outcomes