It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,882
×324

question asked: Feb 28 '13, 11:17 p.m.
question was seen: 5,502 times
last updated: Mar 04 '13, 11:10 a.m.

Related questions

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

0
Gustavo Leyva (3●3●4●5) | asked 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.

4 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Rafik Jaouani (5.0k●1●6) | answered Mar 01 '13, 5:28 p.m.
JAZZ DEVELOPER
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
permanent link
Gustavo Leyva (3●3●4●5) | answered 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
permanent link
Rafik Jaouani (5.0k●1●6) | answered Mar 04 '13, 11:04 a.m.
JAZZ DEVELOPER
Gustavo, can you please specify which RTC version you are using and wether you are using the legacy datamart or the data warehouse?
0
permanent link
Gustavo Leyva (3●3●4●5) | answered 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.

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.