Re: Query needed to display the number of times a project is baseline. (110 Views)
Reply
Occasional Contributor
Sushil Kumar Pradhan
Posts: 5
Registered: ‎02-11-2008
Message 1 of 2 (110 Views)

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
Honored Contributor
Sascha Mohr
Posts: 521
Registered: ‎02-26-2008
Message 2 of 2 (110 Views)

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
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.