Project and Portfolio Management Practitioners Forum
cancel

SQL to get Desicion steps in Subworkflows

Highlighted
Jajcen Harris
Valued Contributor.

SQL to get Desicion steps in Subworkflows

Hello All,

We recently just made a request that has approval steps in the subworkflow. Does anyone know SQL on how to get the approval steps in the subworkflow to show in the portlet?
2 REPLIES
Mahen M
Acclaimed Contributor.

Re: SQL to get Desicion steps in Subworkflows

How should your portlet look like? Please advice.

Regards,
Mahendran M
Alan Delimon
Super Contributor.

Re: SQL to get Desicion steps in Subworkflows

Good morning Jajcen,
Try this query for that information:

SELECT
w.workflow_name,
ws.sort_order,
ws.step_name, ws.STEP_TYPE_CODE
FROM
clm.KWFL_WORKFLOWS w,
clm.KWFL_WORKFLOW_STEPS ws
WHERE
ws.workflow_id=w.workflow_id
and w.workflow_name = 'YOUR WORKFLOW OR SUB WORKFLOW NAME'
and step_type_code = 'APPROVAL'