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

"workitem/workItem/category" element of schema doesn't work in RTC in report designed in RPE

Questions
Tags
Users
Badges
Dmitry A. Lesin
(248●2●69●96) Sep 02 '18, 9:25 a.m.

Hello!

I'm trying to use "workitem/workItem/category" element in Rational Publishing Engine (v6.0.5)report from work item's schema available in Rational Team Concert (v6.0.5).


I found that it works running the report directly in RPE Document Studio. "Category" is value of current parameter defined by user before the report is run. "curCategory" is category of first work item found in accordance to parameters set. You can see that "curCategory" is defined.

In RPE Document Studio

But "curCategory" isn't available when the same report is deployed to RTC and run. This is despite to all other values are displayed for each iterated work item.

In RTC

May be somebody could assume what the problem can be related to.
Thank you!

0 votes

1 answer
2,435 views
0 votes

Accepted answer

Permanent link
Subramanya Prasad Pilar
(4.6k●1●6) Sep 02 '18, 12:59 p.m.
I am not aware of any such issue when document generation is done through RPE Vs RTC. Are you generating report for the same projectArea in both cases?
You may note the difference between workitem/category and workitem/workItem/category. The latter specifies the existing work items first. That is, only if the category has one or more WorkItems assigned to it, it will be shown.
Dmitry A. Lesin selected this answer as the correct answer

0 votes

Comments
Dmitry A. Lesin
Sep 03 '18, 7:38 a.m.

 I have checked regarding "Are you generating report for the same projectArea in both cases?" question. It seems there's no error here.

In parameters, the list of categories is collected from all work items where it was found:

Metadata for category parameter

Collecting occurs in current project area only:

${public}/rpt/repository/workitem?fields=workitem/workItem[projectArea/itemId='${projectAreaUUID}']/(category/(itemId|name)|projectArea/itemId)

I see that correct list of categories is displayed:

List of values of category param

Dmitry A. Lesin
Sep 03 '18, 7:39 a.m.

 If I will try to get all project areas data, it will look like next:


List of project areas

In RPE specification, I'm using next URI to get work items:

https://<SERVER>:9443/ccm/rpt/repository/workitem?fields=(workitem/workItem[projectArea/itemId='_UQdPECxBEeitRbRXL3fkMw']/(id|summary|description|creationDate|modified|type/(id|name)|owner/name|creator/name|modifiedBy/name|allExtensions/(key|largeStringValue)|target/(itemId|name)|projectArea/(itemId|name)|teamArea/name|category/(itemId|name)|priority/(id|name)|auditableLinks/(name|targetRef/(comment|referencedItem/(itemId|itemType|reportableUrl)))))

Dmitry A. Lesin
Sep 03 '18, 7:39 a.m.

 In metadata of "workitems" schema, I'm using next:


${public}/rpt/repository/workitem?fields=(workitem/workItem[projectArea/itemId='${projectAreaUUID}']/(id|summary|description|creationDate|modified|type/(id|name)|owner/name|creator/name|modifiedBy/name|allExtensions/(key|largeStringValue)|target/(itemId|name)|projectArea/(itemId|name)|teamArea/name|category/(itemId|name)|priority/(id|name)|auditableLinks/(name|targetRef/(comment|referencedItem/(itemId|itemType|reportableUrl)))))

You can see that "category/(itemId|name)" is in both cases.
At the stage of setting values in parameters:

Setting parameters in RTC

It seems, everything is correct!

I have only ???????????????? and can not understand where I could be wrong.   :(

Dmitry A. Lesin
Sep 03 '18, 7:43 a.m.

 And take into account that the same report works when running from RPE Document Studio, but works a little bit otherwise in RTC! But it works properly in my local RTC which was temporarily used for development purposes.

Subramanya Prasad Pilar
Sep 03 '18, 12:06 p.m.

I would suggest comparing RPE log with RRDG log. You can check how the URL used is different in RRDG when compared to RPE.

Dmitry A. Lesin
Sep 06 '18, 2:59 p.m.

I can not explain but it works now after redeployment of the report. May be something gone wrong during deployment.

showing 5 of 6 show 1 more comments

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.

Ask a question
Guidelines
FAQ
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
× 12,020
× 481
× 332

Question asked: Sep 02 '18, 9:25 a.m.

Question was seen: 2,435 times

Last updated: Sep 06 '18, 2:59 p.m.

Confirmation Cancel Confirm