Hello All,
I'am trying to find team count in each project through query using count function in oracle. As i'am in the early stages of learning ppm and oracle, it seems a bit tougher. Could anyone help me solving this.
Below is the query i have written.
SELECT
INV.CODE project_code,
INV.NAME project_name,
SRM.ID RESOURCE_ID1,
SRM.FULL_NAME RESOURCE_NAME,
count(*) team_count,
U.LAST_NAME||' '||U.FIRST_NAME RESOURCE_MANAGER
FROM INV_INVESTMENTS INV
JOIN PRTEAM PR ON PR.PRPROJECTID=INV.ID
JOIN SRM_RESOURCES SRM ON PR.PRRESOURCEID=SRM.ID
JOIN CMN_SEC_USERS U ON U.ID=SRM.MANAGER_ID
GROUP BY INV.CODE, INV.NAME, SRM.ID, SRM.FULL_NAME, U.LAST_NAME||' '||U.FIRST_NAME
order by count(*)