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

ppm work plan log table.

SOLVED
Go to solution
Highlighted
Korayk
Occasional Contributor

ppm work plan log table.

Hi everone.

I can select the work plans,schuld_effort,act_effort,  PERC_COMPLETE etc.  from WP_WORK_UNITS table .
But I want to see the changes on the work plan.

For example if a work unit changes 3 times. I want to get 3 rows about this unit.
Thanks.

 

 

 

2 REPLIES
Utkarsh_Mishra
Honored Contributor
Solution

Re: ppm work plan log table.

Hi,

 

You can get thes details form Audit logs...

 

Just put your Project Request id in the SQL

 

SELECT * FROM ITG_AUDIT_EVENTS WHERE ENTITY_TYPE = 59

AND ENTITY_ID IN (SELECT TASK_INFO_ID FROM WP_TASKS WHERE WORK_PLAN_ID IN

(SELECT WORK_PLAN_ID FROM PM_WORK_PLANS WHERE PROJECT_ID = (SELECT PROJECT_ID FROM PM_PROJECTS WHERE PFM_REQUEST_ID = <YOUR_REQUEST_ID>)))

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
Korayk
Occasional Contributor

Re: ppm work plan log table.

Thanks for your reply. It was very usefull.

//Add this to "OnDomLoad" event