It's all about the answers!

Ask a question

RTC workitems report in RPE

sreenath v (7839) | asked Nov 02 '18, 10:00 a.m.


How to get list of all TaskA workitems and it's child Task B workitems in RPE report?
2.when am giving team area query in RPE for RTC datasource it's not generating team area name.Is this any defect or issue with me?


3 answers

permanent link
Kenji Sarai (96029) | answered Nov 05 '18, 8:40 p.m.

Hi Sreenath,

1. Here is the example of Reportable REST query to get all links for workitem 40.
In RPE Workitem datasource, it is located in workitem/workItem/auditableLinks///
Set a native filter using auditableLinks[name=' ] or RPE filter to limit to child relationship.

2. Likewise, here is the all info you can get from workitem 40.
I cannot find Team Area name either. Perhaps this is a limitation of RTC (not RPE).

permanent link
sreenath v (7839) | answered Nov 06 '18, 11:23 p.m.
edited Nov 06 '18, 11:23 p.m.
I got the solution,
as you said it is to get report just for a workitem.

https://ucd-demo:9443/ccm/rpt/repository/workitem?fields=workitem/workItem[projectArea/itemId=_2_rzIbyMEeiBc_6BcdfL8w and type/id='task']/(type/*|id|summary|reportableUrl|children/*|children/type/*)

if u use this we will able to get report of all work item as a query.

Anjuri Kelaiya commented Dec 27 '18, 8:31 a.m. | edited Dec 27 '18, 8:31 a.m.

Hi Kenji, Sreenath,

I am trying to get linked work items information using https://server/ccm/rpt/repository/workitem?fields=workitem/workItem[id=40]/auditableLinks/targetRef//referencedItem/reportableUrl as mentioned above but it is not working for me.. Report generation process ends up with the errors: Can not access to the OAuthentication URL.
If it's working for you, could you please guide me on this?

permanent link
Geoffrey Clemm (30.1k33035) | answered Nov 11 '18, 11:23 p.m.

For #2, the team area name is a computed property (based on the FiledAgainst and PlannedFor properties), not a property that is stored in the repository, which I expect is why RPE cannot report on it.

Your answer

Register or to post your answer.