It's all about the answers!

Ask a question

How to extract active project area list and available roles in each project from RTC 4.0.3


Faizal Rahman (821015) | asked Feb 09 '17, 12:42 a.m.

I am using RTC 4.0.3 version and having around 400 active project areas. I would to like to extract all active project area name list and available roles under each project area.

Please suggest me an option.

3 answers



permanent link
Ralph Schoon (63.7k33648) | answered Feb 09 '17, 3:48 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

permanent link
Donald Nong (14.5k614) | answered Feb 09 '17, 4:18 a.m.

permanent link
Dinesh Kumar B (4.1k413) | answered Feb 09 '17, 8:55 a.m.
JAZZ DEVELOPER

There are multiple ways.. if you are willing to head Plain Java API way, here is all the information you need for it :
https://rsjazz.wordpress.com/2012/12/09/analyzing-a-aroject-areas-members-and-roles-using-the-plain-java-client-libraries/


and if you would like to go for Reportable REST API way :
 
On a Browser Address Bar, provide the following URL :
https://<repo_url>:<port>/ccm/rpt/repository/foundation?fields=projectArea/projectArea[name='<nameofprojectarea>']/(name|allTeamAreas/(roleAssignments/(contributor/name|contributorRoles/name)))

after replacing <repo_url>, <port> and <nameofprojectarea> in the above url with appropriate values from your instance.

Sample Output with :
    <repo_url> = clm602.ibm.com
    <port> = 9443
and
    <nameofprojectarea> = 56458_UserNotPartOfTeamArea
 
would be :

<foundation Version="1.0.0" rel="next" href="https://clm602.ibm.com:9443/ccm/rpt/repository/foundation?id=_s4bFUO7JEeaFpuXOGjoZGA&fields=projectArea%2FprojectArea%5Bname%3D%2756458_UserNotPartOfTeamArea%27%5D%2F%28name%7CallTeamAreas%2F%28roleAssignments%2F%28contributor%2Fname%7CcontributorRoles%2Fname%29%29%29&size=100&pos=100">
    <projectArea>
        <name>56458_UserNotPartOfTeamArea</name>
        <allTeamAreas>
            <roleAssignments>
                <contributor>
                    <name>builduser2</name>
                </contributor>
                <contributorRoles>
                    <name>Scrum Master</name>
                </contributorRoles>
                <contributorRoles>
                    <name>default</name>
                </contributorRoles>
            </roleAssignments>
            <roleAssignments>
                <contributor>
                    <name>builduser1</name>
                </contributor>
                <contributorRoles>
                    <name>Scrum Master</name>
                </contributorRoles>
                <contributorRoles>
                    <name>default</name>
                </contributorRoles>
            </roleAssignments>
        </allTeamAreas>
    </projectArea>
</foundation>


More about Reportable REST APIs is here :
     https://jazz.net/wiki/bin/view/Main/ReportsRESTAPI#projectArea_type_com_ibm_team_pr

hope this helps


Comments
Dinesh Kumar B commented Feb 09 '17, 8:56 a.m.
JAZZ DEVELOPER

oops... my page refreshed only after i posted my answer... and see that Ralph and Donald have already answered it all... :)

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.