Primavera (MOSC)

MOSC Banner

deleted activities shows when retrieving data from PMDB task table in excel, P6

edited Jun 3, 2015 9:04PM in Primavera (MOSC) 3 commentsAnswered ✓

Hi There,

I created a macro to retrieve activities of a specific project from P6 in Excel, the sql statement is like this :

"Select a.task_id, b.wbs_name, a.task_code, a.task_name, a.early_start_date,a.early_end_date, a.act_start_date, a.act_end_date, a.status_code  FROM TASK a join PROJWBS b ON a.wbs_id=b.wbs_id where a.proj_id = '" + projID + "' "

It connects directly to PMDB (not SDK), however after retrieving activities, in excel I see some activities which already been deleted from the project in P6.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center