Project Server Baseline

[Todd Zetlan]

I have a report that is created and I need to do a comparison for specific tasks of the current task start date and the latest baselined task start date. My question is how can I easily determine through SQL what the latest baseline is so I know which column to include (i.e. ProjectBaseline2StartDate, etc.)?

EggHeadCafe - Software Developer Portal of Choice
Refactoring with the Parameterized Factory Pattern
http://www.eggheadcafe.com/tutorial...e-790afdea5895/refactoring-with-the-para.aspx

 

[Jonathan Sofer [MVP]]

There is nothing in the database that can be used to determine which
baseline number was the latest one to be saved. You need to set a process
so that you know which baselines are being used for which stage of the
project.

If you want to go with a custom solution, I have seen a macro solution (so I
know it is possible) that captures the baseline save event, the time it was
taken, the user's account name and the baseline number as well as whether it
was a full or partial baseline and then commits this data to a custom table
in the database on the project save event.

Jonathan


in message
news:[email protected]...

 

[Gary Chefetz]

It's a property in the Project Object model. Maybe in P15 we'll get
something in the PSI for baseline and calendar properties and manipulation.