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

Is there a way to output the Description system attribute in JRS reports?

Questions
Tags
Users
Badges
Janet Charbonneau
(85●27●54) edited
Jun 05 '20, 1:47 p.m.

My customer is using Jazz 6.0.4 and the data warehouse.  When creating a JRS report containing Stories and Epics, they want to be able to have the system attribute Description as one of the columns.  It doesn't appear to be a valid attribute to add to the report.  I found a similar question, but it was from 2016.  Is it possible to output the Description attribute using the data warehouse (not LQE)?

0 votes

1 answer
1,807 views
0 votes

One answer

Permanent link
Bartosz Chrabski
(3.4k●2●29●49) Jun 05 '20, 1:40 p.m.

 Hi Jannet,


JRS was not available in 2011, so the questions you found may not be relevant at all.

In JRS is you will use DCC as a data source you do not have access to Work Item Description, but as you mentioned you can do it using LQE.

I am not sure if WI description is going to the data warehouse database but if yes, I think then you should be able to access this data using custom SQL query.

1 vote

Comments
Janet Charbonneau
Jun 05 '20, 1:50 p.m.
Sorry, the 2011 was a typo.  It was 2016 and I have corrected my post.

Thanks for your answer.  I never considered using a custom SQL query.  I will give that a try to see if that works.

Bartosz Chrabski
Jun 05 '20, 3:45 p.m.
Janet,

First check if the description is in data warehouse :).

I am not sure if DCC collects this value.

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
× 360

Question asked: Jun 05 '20, 12:47 p.m.

Question was seen: 1,807 times

Last updated: Jun 05 '20, 3:45 p.m.

Confirmation Cancel Confirm