It's all about the answers!

Ask a question

RTC workitems report in RPE


sreenath v (7863) | 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 (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.
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 (7863) | 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.