Skip to content
ProjectControls.com
Oracle Primavera - PM6

P6 SQL Database - Get WBS Start and Finish Dates

In the Open Standard
C MollandMember for 11 years 5 months
Created
3
5
0

Hello

I am developing an application which pulls data from our P6 SQL database. In my application I want to display WBS and Task items hierarchically and beside each item display the start/finish dates.

In SQL I can write a Common Table Expression which will recursively loops through the WBS/Task data and calculates the start and finish dates for all of the WBS items but it is slow and I suspect unneccesary.

Assuming that the start and finish dates for each WBS item may be pre-calculated within the depths of the SQL data somewhere, how can I write a SELECT satatement to get WBS items included their related start/finish dates please?

Thank you.

Chris

Save Follow Follow forum Report
Reply New topic

3 replies

Oldest first
  1. 0
    Zoltan Palffy ·
    #1

    easier to just summarize the

    easier to just summarize the WBS and roll it up

    Report
  2. 0
    C Molland ·
    #2

    Thanks for your thoughts, but

    Thanks for your thoughts, but not being a Primavera user I don't understand the comment.

    What I wanted to establish is - are the start/finish dates for all wbs items stored within the SQL database or are they calculated 'on the fly' by the Primavera application? The same goes for finding out if a Task/WBS is on the Critical Path.

    I can calculate a WBS item's start/finish dates but if it is already calculated and stored in the SQL databse I can just write a SQL SELECT statement and get it.

    Report
  3. 0
    Zoltan Palffy ·
    #3

    all dates are calculated all

    all dates are calculated 

    all you have to do is to goto group and sort

    then group by wbs

    make sure that show group totals and show grand totals is checked in the group and sort

    then select view collapse to then in the drop down select wbs

    thats it of course make sure that you have a column for the start date and a column for the finish date

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?