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

Create a BIRT report that display all work items where a comment has been added in the las 10 days

Questions
Tags
Users
Badges
Gustavo Leyva
(3●3●4●5) Feb 28 '13, 11:17 p.m.
Hi All,

I am trying to create a BIRT report that displays all work items where a comment/discussions has been added in the last 10 days.

I can extract work item data; comment_count, workitem id, Project Area, Create date, Modified date, nevertheless I can´t find the snapshot or table that contains the history or changes of a work item or a way to compare the actual number of comment/discussions vs the past number of comment/discussions.

Thanks in advance.

0 votes

4 answers
7,543 views
0 votes

4 answers

Permanent link
Rafik Jaouani
JAZZ DEVELOPER (5.0k●1●6) Mar 01 '13, 5:28 p.m.
Try the table named: WORKITEM_CHNGS_TO from WORKITEMS_SNAPSHOT. The table has a column named COMMENT_COUNT_CHANGES which gives you the increase in comment count since the previous state of the work item.

0 votes

Permanent link
Gustavo Leyva
(3●3●4●5) Mar 04 '13, 10:55 a.m.
 Hi Rafik,

I want to thank you for  your answer and apologize for my delayed answer.

I found the field you mentioned, nevertheless I can not find a field with the Work Item ID and related with other WI data.

Do you know if there is a field like WI_ITEMID or WI_ID?

Thanks in advance.

Regards,
Gustavo Leyva.

0 votes

Permanent link
Rafik Jaouani
JAZZ DEVELOPER (5.0k●1●6) Mar 04 '13, 11:04 a.m.
Gustavo, can you please specify which RTC version you are using and wether you are using the legacy datamart or the data warehouse?

0 votes

Permanent link
Gustavo Leyva
(3●3●4●5) Mar 04 '13, 11:10 a.m.
 Hi Rafik, 
I am working with RTC v4.0, Jazz data source and I think I am using the data ware house.

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.

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

Question asked: Feb 28 '13, 11:17 p.m.

Question was seen: 7,543 times

Last updated: Mar 04 '13, 11:10 a.m.

Confirmation Cancel Confirm