Project and Portfolio Management Practitioners Forum
cancel

How to find the active workflow step number

SOLVED
Go to solution
Highlighted
Satish_Ganga
Trusted Contributor.

How to find the active workflow step number

Hi guys,

 

How to find the active workflow step number,step name  of a request in the backend by using a query.

 

thanks in advance.

5 REPLIES
Erik Cole
Acclaimed Contributor.

Re: How to find the active workflow step number

select kcrt_request_util.get_workflow_active_steps(35377) from dual

 

Also, look at the thread below called "Need Query to get transaction details "

Satish_Ganga
Trusted Contributor.

Re: How to find the active workflow step number

thanks for response.Actually i need where the request is in the workflow(for example the request at workflow step No.6 like that).

Erik Cole
Acclaimed Contributor.
Solution

Re: How to find the active workflow step number

If you want the step sequence number, just borrowing from that function but grabbing that field...

 

SELECT kws.sort_order
    FROM kwfl_workflow_instances kwi, kwfl_workflow_instance_Steps kwis, kwfl_workflow_Steps kws
    WHERE kwi.top_instance_source_type_code = 'IR'
    AND kwi.top_instance_source_set_id = 35377
    AND kwi.top_instance_source_id = 35377
    AND kwi.workflow_instance_id = kwis.workflow_instance_id
    AND kwi.current_flag = 'Y'
    AND kwis.active_flag = 'Y'
    AND kwis.workflow_step_id = kws.workflow_step_id
    AND kws.step_type_code not in ('WORKFLOW','CONDITION')
    ORDER BY 1

Satish_Ganga
Trusted Contributor.

Re: How to find the active workflow step number

Thanks alot for your quick and accurate response............:-)

Satish_Ganga
Trusted Contributor.

Re: How to find the active workflow step number

what's the exactly use of coloumn 'instance_source_type_code' ????????