Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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?

0 votes


Accepted answer

Permanent link
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"]/*
June Boston selected this answer as the correct answer

0 votes

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.

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,014
× 481
× 332

Question asked: Apr 02 '14, 7:58 p.m.

Question was seen: 5,407 times

Last updated: Apr 04 '14, 2:58 p.m.

Confirmation Cancel Confirm