Query to show tasks where process is in error

[navzjoshi00]

Does anyone have a query to show tasks where process is in error ?

 

e.g. if there is a process on task object, I would like to know the following -

 

1. Task Name

2. Task Id (internal would do)

3. Project Code

4. Project Name

5. Process Name

6. Process Step

 

Having a bad day, and hence checking if anyone has it already

 

NJ

[Legacy User]

I think this should work for you. I left the Process Name and Step Name to you to add.

 

SELECT    II.CODE,
          II.NAME,
          PT.PRID,
          PT.PREXTERNALID,
          PT.PRNAME ,
          BDP.PROCESS_CODE, 
          BRP.STATUS_CODE,
          BDS.STEP_CODE
FROM      INV_INVESTMENTS II INNER JOIN 
          PRTASK PT ON
          II.ID = PT.PRPROJECTID INNER JOIN 
          BPM_RUN_OBJECTS BRO ON 
          PT.PRID = BRO.OBJECT_ID INNER JOIN 
          BPM_RUN_PROCESSES BRP ON 
          BRO.PK_ID = BRP.ID INNER JOIN 
          BPM_DEF_PROCESS_VERSIONS BDPV ON 
          BRP.PROCESS_VERSION_ID = BDPV.ID INNER JOIN
          BPM_DEF_PROCESSES BDP ON 
          BDPV.PROCESS_ID = BDP.ID INNER JOIN 
          BPM_RUN_STEPS BRS ON 
          BRP.ID = BRS.PROCESS_INSTANCE_ID INNER JOIN 
          BPM_DEF_STEPS BDS ON 
          BRS.STEP_ID = BDS.ID
WHERE     BRO.TABLE_NAME = 'BPM_RUN_PROCESSES' AND 
          BRO.OBJECT_TYPE_CODE = 'task' AND 
          BRS.STATUS_CODE IN ('BPM_SIS_ERROR') 

[navzjoshi00]

Thanks Andrew , will give it a shot and let you know

 

NJ