Project and Portfolio Management Practitioners Forum
cancel

Active workflow step details

Highlighted
PPMRam
Super Contributor.

Active workflow step details

Hi All,

 

How to get active workflow step name either it is condition or decision. Is there any flag indicates the active workflow step name? Please provide sample query or table name.

Regards,

2 REPLIES
Jason Nichols K
Acclaimed Contributor.

Re: Active workflow step details

Here is a query I used to find the Workflow Step Instance ID of a specific step in a workflow.  It has all of the connections you need to get to what you need:

 

    SELECT kwis.WORKFLOW_INSTANCE_STEP_ID
    INTO HoldStepID
    FROM KWFL_WORKFLOW_STEPS kws
       , KWFL_WORKFLOW_INSTANCES kwi
       , KWFL_WORKFLOW_INSTANCE_STEPS kwis
    WHERE kwi.TOP_INSTANCE_SOURCE_ID = requestID
      AND kwis.WORKFLOW_INSTANCE_ID = kwi.WORKFLOW_INSTANCE_ID
      AND kwis.ACTIVE_FLAG = 'Y'
      AND kwis.WORKFLOW_STEP_ID = KWS.WORKFLOW_STEP_ID
      AND kws.STEP_NAME = '<Step Name Goes Here>';

Oscar_Pereira
Honored Contributor.

Re: Active workflow step details

You can find more details on PPM database model in the guide:

 

http://support.openview.hp.com/selfsolve/document/KM1014814

 

Regards

Oscar P