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 |
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)) Comments Correction, not both project and plan but only plan names under the projectArea
Hi Charlie
|