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

RTC Reports Creating

Hi,

Which table from JAZZ database I must use to see recently created work items and also, their states.
I used LIVE_WORKITEM_CNT table, I got some results which I wanted, but within the last date three months ago. When I change some of these work items, I see the change in report, but I am wondering why I can't get currently created work items?
Maybe I must update snapshot data for WORKITEMS_SNAPSHOT? Or I use wrong table to retrieve data?

For the beginning, I would like to track work item changes through report, and any help would be appreciated.

Thanks,
Milan

0 votes



2 answers

Permanent link
On 4/14/2010 12:23 PM, milan.krivic wrote:
Hi,

Which table from JAZZ database I must use to see recently created work
items and also, their states.
I used LIVE_WORKITEM_CNT table, I got some results which I wanted, but
within the last date three months ago. When I change some of these
work items, I see the change in report, but I am wondering why I
can't get currently created work items?
Maybe I must update snapshot data for WORKITEMS_SNAPSHOT? Or I use
wrong table to retrieve data?

For the beginning, I would like to track work item changes through
report, and any help would be appreciated.

Thanks,
Milan


Milan,

The LIVE_WORKITEM_CNT table should give you up-to-date information about
the work items in the repository, independently of whether snapshots
have run. Could you provide some more information about what isn't
working properly?

james
RTC Reports Team Lead

0 votes


Permanent link
On 4/14/2010 12:23 PM, milan.krivic wrote:
Hi,

Which table from JAZZ database I must use to see recently created work
items and also, their states.
I used LIVE_WORKITEM_CNT table, I got some results which I wanted, but
within the last date three months ago. When I change some of these
work items, I see the change in report, but I am wondering why I
can't get currently created work items?
Maybe I must update snapshot data for WORKITEMS_SNAPSHOT? Or I use
wrong table to retrieve data?

For the beginning, I would like to track work item changes through
report, and any help would be appreciated.

Thanks,
Milan


Milan,

The LIVE_WORKITEM_CNT table should give you up-to-date information about
the work items in the repository, independently of whether snapshots
have run. Could you provide some more information about what isn't
working properly?

james
RTC Reports Team Lead

Hi James,

It's all ok now. I was testing reports in Report Design perspective, so temporary, I could see only past results as I mentioned before, but when I uploaded report template, I got what I wanted.

Anyway, thanks for the help.

Regards,

Milan

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.

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

Question asked: Apr 14 '10, 12:09 p.m.

Question was seen: 3,892 times

Last updated: Apr 14 '10, 12:09 p.m.

Confirmation Cancel Confirm