Nitesh Gupta Absent Member.
Absent Member.
223 views

How to find last update date of a project work plan

I need to find the last update date of the work plans of the projects. We have some tables like wp_tasks, itg_audit_events, pm_work_plans. These tables provide last update date for a work plan. But that data doesn't match with the data that is shown in the project audit trail on the project details page.

Could any one suggest any solution for this problem.
0 Likes
5 Replies
Sangiliraja_1 Absent Member.
Absent Member.

Re: How to find last update date of a project work plan

Hi Nitesh,

You can use the last update column of the table WP_TASKS to get the last update on any of the tasks in a project workplan.

Thanks
Sangiliraja.P
0 Likes
Nitesh Gupta Absent Member.
Absent Member.

Re: How to find last update date of a project work plan

Hi
I have two tables. wp_tasks (last_update_date column) and itg_audit_events (event_date column). The table itg_audit_events is used based on the container1_id column (as work plan id) or entity_id (as project id). While the wp_tasks table is used based on the column work_plan_id.
But the problem is:for some projects I get the work plan update date from one table while for some other projects, it is available in the second table. I am unable to find any appropriate logic to decide which table to be used in what situation.
0 Likes
Mahen M Frequent Contributor.
Frequent Contributor.

Re: How to find last update date of a project work plan

By project audit trail on the project details page, You mean to say the Last 'Status' section?(Shown in snap)

If yes, then your workplan and tasks tables is not releted with this data.

Regards,
Mahendran M
0 Likes
Nitesh Gupta Absent Member.
Absent Member.

Re: How to find last update date of a project work plan

Hi Mahendran

I am talking about the Project Audit Trial. Its link is available on the top left of the Project Details Page. I have attached a snapshot of one Project Audit Trail.
0 Likes
Super Contributor.. JodieOndrejka Super Contributor..
Super Contributor..

Re: How to find last update date of a project work plan

The Last Update Date in the PM_WORK_PLANS and in the WP_TASKS table also gets updated by services that run.  We have seen the Last Updated By ID of 1 which is the Admin User.  We are looking to find when the last time the actual PM of the project updated a task.

I've started trying to use the ITG_AUDIT_EVENTS table and using CONTAINER0_ID for the task # and CONTAINER1_ID for the Work Plan #.  The Last Updated By here has the actual PM.  HOWEVER, some of these dates aren't matching what is in the Work Plan Audit Trail.  Where is the Work Plan Audit Trail getting its information?  Is the ITG_AUDIT_EVENTS table the one I really want to use or is there yet another table to look at?

Thanks

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.