Working with apt planSnapshot reporting
We are trying to use RPE to report on the data stored in a planSnapshot, namely the start/end dates and the work items contained within. We are using templates based off the Formal Project Process. The documentation is sparse in this matter and I cannot filter my query results or see all the data I'm looking for. I can get a list of all the project areas within the structure of apt with this:
https://server:port/ccm/rpt/repository/apt?fields=planSnapshot/projectArea/*
Likewise I can get the actual snapshots like so:
https://server:port/ccm/rpt/repository/apt?fields=planSnapshot/iteration/*
Question: Where can I filter the iteration results to bring me only those from a specific project area? I have inserted an xpath filter like [projectArea/name="PROJECT"] in numerous parts of the query, but it tells me that it is a bad filter as it returns multiple values. I understand the /iteration and /projectArea XML trees are parallel and not within one another, so I'm confused as to how to filter these results.
What is the purpose of the <reportableUrl> value? It looks like it appends things to the reporting api call before the ?fields query, but the URl is not helping me in any way. I thought it might be part of the solution.
Also, does this planSnapshot API expose the work items contained within the snapshots at all provide some way to locate them and use them in reporting?
Accepted answer
Hi June,
Only partial answer on your questions:
I used following statement:
https://your-server:9443/ccm/rpt/repository/apt?fields=planSnapshot/projectArea[name="PROJECT"]/*
and this one:
https://your-server:9443/ccm/rpt/repository/apt?fields=planSnapshot/iterationPlanRecord/projectArea[name="PROJECT"]/*
Only partial answer on your questions:
I used following statement:
https://your-server:9443/ccm/rpt/repository/apt?fields=planSnapshot/projectArea[name="PROJECT"]/*
and this one:
https://your-server:9443/ccm/rpt/repository/apt?fields=planSnapshot/iterationPlanRecord/projectArea[name="PROJECT"]/*
Comments
Thank you; it turns out in the end, the details I need are actually stored with the Work Items, as their plannedStartDate and plannedEndDate values are derived from their current plan and the planning section doesn't contain this data. Still, your answer helped me filter the plans by project which is also useful.