The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Where can I get the Status History

Highlighted
Korayk
Occasional Contributor

Where can I get the Status History

Hi .

I want to get a request status history. I mean For example there are 3 steps in a request : 1-Start 2-InProgress 3-Closed.

If this request could reach the status 3 I just want to know the previous status update date 1 and 2.

I want to learn all the status dates. How can I find these info's in PPM database.

 

 

I have a script like below and i want to add this info to script.

select
kr.REQUEST_ID AS TakipNo ,kr.DESCRIPTION As Aciklama,t.REQUEST_TYPE_NAME As ProjeTipi ,kr.STATUS_CODE As Status ,kr.LAST_UPDATE_DATE As StatusTarihi
,wtp.SCHED_EFFORT As PlanlananAdamGun ,wtp.SCHED_START_DATE As PlanlananBaslangicTarihi,wtp.SCHED_FINISH_DATE As PlanlananBitisTarihi
,u.USERNAME ,100 As EtkilenmeYuzdesi
from PPMKTPROD_USR.wp_tasks wt
,PPMKTPROD_USR.wp_work_units wu
,PPMKTPROD_USR.RSC_RESOURCES rr
,PPMKTPROD_USR.KNTA_USERS u
,PPMKTPROD_USR.wp_task_schedule wtp
,PPMKTPROD_USR.wp_task_info wti
,PPMKTPROD_USR.pm_work_plans wp
,PPMKTPROD_USR.pm_projects proj
,PPMKTPROD_USR.kcrt_requests kr
,ppmktprod_usr.kcrt_request_types t
WHERE
wt.task_schedule_id = wtp.task_schedule_id
AND wu.TASK_ID = wt.TASK_ID
AND rr.RESOURCE_ID = wu.RESOURCE_ID
AND rr.USER_ID = u.user_id
AND wt.task_info_id = wti.task_info_id
AND wt.work_plan_id = wp.work_plan_id
AND wp.project_id = proj.project_id
AND wp.entity_type = 'WORK_PLAN'
AND kr.request_id(+) = proj.pfm_request_id
AND kr.request_type_id = t.request_type_id
1 REPLY
sebastianrm
Super Collector

Re: Where can I get the Status History

K,

Check this tables.

KWFL_STEP_TRANSACTION_HISTORY: ELIGIBLE, COMPLETED, or ERROR. For condition step transactions, a history row is inserted when the status becomes PENDING or COMPLETED.
ELIGIBLE, COMPLETED, or ERROR. For condition step transactions, a history row is inserted when the status becomes PENDING or COMPLETED.

KWFL_STEP_TRANSITIONS:  Each row defines a transition from one workflow step to another

 

Regards,

 

 

S

//Add this to "OnDomLoad" event