AnsweredAssumed Answered

How do I retrieve the title field for the tasks within a workflow?

Question asked by rparrish on May 16, 2013
Latest reply on Jan 23, 2014 by BenCroffut603954

I created the following query to list all of the workflows and their associated tasks that executed for a particular time period:

 

select AH_Client Client,

       AH_Idnr Rec_ID,

       OH_Name Name,

       AJPP_Lnr Item_No,      

       AJPP_Object Task_Name,

       AH_TimeStamp1 Activate_Time,

       AJPP_StartTime Start_Time,

       AJPP_EndTime End_Time,                        

       AH_Status Parent_Status,

       AJPP_Status Task_Status

  FROM OH INNER JOIN AH ON OH_Idnr = AH_OH_Idnr

  left outer join AJPP

  ON AJPP_AH_Idnr = AH_Idnr 

  where ah_client = '2'  AND             

        OH_Name like 'PBW_%' AND

        AH_TimeStamp2 > '09/09/2012 05:00:00' AND       

        AH_TimeStamp2 < '09/16/2012 04:59:59' ;

 

The users would now like to include the “title” field for each of the tasks within the workflow.  If I just add the OH_Title field to the query, it will return the workflow title instead of the task titles.  Has anyone developed a query that includes the task titles?

Outcomes