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

RTC workitems report in RPE

 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

0 votes



3 answers

Permanent link

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).

0 votes


Permanent link
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.

0 votes

Comments

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

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.

0 votes

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
× 6,121

Question asked: Nov 02 '18, 10:00 a.m.

Question was seen: 3,241 times

Last updated: Dec 27 '18, 8:31 a.m.

Confirmation Cancel Confirm