Primavera (MOSC)

MOSC Banner

While querying the primavera tables, what column/field can be used to filter projects from baselines

edited Sep 11, 2018 5:41PM in Primavera (MOSC) 1 commentAnswered

When we query the database tables, what column/field can e used to filter out the baseline projects:

Example : 

Select Count(T.PROJ_ID), P.Name from Projectx P

Inner join Task T on P.Proj_ID=T.Proj_id

where T.Create_Date>=P.SumActualStartDate

and P.SumActualStartDate is not null

  group by P.Name

The above query lists the results for baseline projects as well.What project field is apt to be used to filter out baseline projects.

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