Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

SQL to get Desicion steps in Subworkflows

Highlighted
Jajcen Harris
Occasional 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
Honored Contributor

Re: SQL to get Desicion steps in Subworkflows

How should your portlet look like? Please advice.

Regards,
Mahendran M
Alan Delimon
Regular Collector

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'
//Add this to "OnDomLoad" event