It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,785
×6,076
×1,036
×482

question asked: Nov 02 '18, 10:00 a.m.
question was seen: 2,543 times
last updated: Dec 27 '18, 8:31 a.m.

Related questions

FAQ - How this Forum works

RTC workitems report in RPE

0
sreenath v (78●1●67) | 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

Most liked answers ↓|Newest answers|Oldest answers

0
permanent link
Geoffrey Clemm (30.1k●3●30●35) | 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.
0
permanent link
sreenath v (78●1●67) | 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?

0
permanent link
Kenji Sarai (960●2●9) | 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).

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.