Is there a way to query all plan of a given project area using REST API
RTC 4.0.5
Is there a way to get all plan of a give project area using Rest API
I was able to query all plans by using
https://server/ccm/rpt/repository/apt?fields=apt/iterationPlanRecord/%28projectArea/%28name%29%29/
and I tried
https://server/ccm/rpt/repository/apt?fields=apt/iterationPlanRecord[projectArea/name=%27CLM%20Sandbox%27]/%28projectArea/%28name%29%29
to filter those belonging to Project CLM Sanbox
But then I get Error 500: CRRED8022E: Non Queryable Field: projectArea/name
do i something wrong, or is the REST API of apt not able to filter on ProjectArea
Thank you
erwin
Is there a way to get all plan of a give project area using Rest API
I was able to query all plans by using
https://server/ccm/rpt/repository/apt?fields=apt/iterationPlanRecord/%28projectArea/%28name%29%29/
and I tried
https://server/ccm/rpt/repository/apt?fields=apt/iterationPlanRecord[projectArea/name=%27CLM%20Sandbox%27]/%28projectArea/%28name%29%29
to filter those belonging to Project CLM Sanbox
But then I get Error 500: CRRED8022E: Non Queryable Field: projectArea/name
do i something wrong, or is the REST API of apt not able to filter on ProjectArea
Thank you
erwin
2 answers
The first one should grab the project names only rather than plans. In order to filter the Reportable REST API, you need to comply with XPATH syntax.
The following syntax should return both project and plan name back. I found that /projectArea/name and /name (for plan) is located in the same level of xml node.
https://server:9443/ccm/rpt/repository/apt?fields=apt/iterationPlanRecord/(projectArea[name='JKE Banking (Change Management)']|(name))
The following syntax should return both project and plan name back. I found that /projectArea/name and /name (for plan) is located in the same level of xml node.
https://server:9443/ccm/rpt/repository/apt?fields=apt/iterationPlanRecord/(projectArea[name='JKE Banking (Change Management)']|(name))
Comments
Hi Erwin,
do you get any help (esp. from the 2nd URL) from the table provided in the document cited below:
http://sleroyblog.wordpress.com/2013/04/09/querying-rqm-40-through-oslc-and-rest-api/#cs_access_thru_rest ?
Regards,
Stéphane
do you get any help (esp. from the 2nd URL) from the table provided in the document cited below:
http://sleroyblog.wordpress.com/2013/04/09/querying-rqm-40-through-oslc-and-rest-api/#cs_access_thru_rest ?
Regards,
Stéphane
Comments
