Project and Portfolio Management Support and News Forum
Showing results for 
Search instead for 
Do you mean 

Query needed to display the number of times a project is baseline.

Occasional Contributor

Query needed to display the number of times a project is baseline.

Hi,

We are using PPM 7.1 (SP 5).
Could you please help in which table I should query to get the number of times a project is baseline?

If you could send sample query that would be great.

Thanks in advance.

Regards,
Sushil
1 REPLIES
Highlighted
Honored Contributor Honored Contributor

Re: Query needed to display the number of times a project is baseline.

Hello Sushil,
this should solve your request:

SELECT bl.project_id, (SELECT WORK_PLAN_NAME FROM pm_work_plans wp WHERE wp.project_id = bl.project_id AND wp.entity_type = 'WORK_PLAN') Projectname, Count(*)
FROM pm_work_plans bl
WHERE bl.entity_type = 'BASE_LINE'
GROUP BY bl.project_id

Regards
Sascha