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

Time between two steps

Highlighted
babuchsh
Occasional Contributor

Time between two steps

Hi ,

Can anyone help me out to calculate the total duration of time on a particular step.

thanks in advance
2 REPLIES
Alexander (Sua)
Regular Collector

Re: Time between two steps

Could you give more details what you need?
Surendra Poosar
Frequent Visitor

Re: Time between two steps

Try this......

select kr.request_id, krt.REQUEST_TYPE_NAME,
kws.step_name ,
(round((kst.last_update_date - kst.CREATION_DATE)*1440)) mins
from kwfl_step_transactions kst,
kcrt_requests kr,
kwfl_workflow_steps kws,
kcrt_request_types krt
where 1=1
and kst.instance_source_set_id = kr.request_id
and kst.workflow_step_id = kws.workflow_step_id
--and kr.request_id in (50911)
and kst.INSTANCE_SOURCE_TYPE_CODE = 'IR'
and kws.STEP_TYPE_CODE = 'APPROVAL'
and kr.request_type_id = krt.request_type_id
and to_char(trunc(kr.CREATION_DATE), 'YYYY') = '2008'
--group by kr.request_id, krt.REQUEST_TYPE_NAME
order by kr.request_id
//Add this to "OnDomLoad" event