It's all about the answers!

Ask a question

RTC workitems report in RPE


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

 Hi,

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?

Thanks

3 answers



permanent link
Kenji Sarai (96039) | 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.
https://server/ccm/rpt/repository/workitem?fields=workitem/workItem[id=40]/auditableLinks/targetRef//
In RPE Workitem datasource, it is located in workitem/workItem/auditableLinks///
Set a native filter using auditableLinks[name='com.ibm.team.workitem.linktype.... ] or RPE filter to limit to child relationship.

2. Likewise, here is the all info you can get from workitem 40.
https://server/ccm/rpt/repository/workitem?size=100&fields=workitem/workItem[id=40]/
///*
I cannot find Team Area name either. Perhaps this is a limitation of RTC (not RPE).


permanent link
sreenath v (78680) | 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.

Comments
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.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

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.


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.