How to get State date using BIRT Report

Fábio Castro (63●1●12●15) | asked Nov 14 '13, 10:36 a.m.

I would like to show in my report (by BIRT) the date of some State, I mean the date when the Workitem was moved to specific states.

I tried to use table Workitem_Chngs, but I can not see anything in this Table.

How can I show in my BIRT report the date of specifics states ?

Comments

Fábio Castro commented Nov 14 '13, 10:36 a.m.

Just to know, I'm using RTC 4.0.2

Fábio Castro commented Nov 18 '13, 5:42 p.m.

No one know how to do it?

One answer

Most liked answers ↑|Newest answers|Oldest answers

permanent link

ankur sharma (662●1●22●28) | answered Nov 15 '13, 4:40 a.m.
JAZZ DEVELOPER

Look for the WORKITEM_STATES in the WorkItem snapshot. The timestamp column will give you the dates.

Comments

Fábio Castro commented Nov 17 '13, 9:08 a.m.

I created a dataset of this Table with my Project Area ItemID parameter and without parameters and it is empty.

ankur sharma commented Nov 19 '13, 4:54 a.m.

JAZZ DEVELOPER

You have datawarehouse configured? And is Work Items ETL running fine? I don't see any other reason why it should be empty. Can you contact IBM support so it can be pursued in detail

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.

It's all about the answers!

Related questions

How to get State date using BIRT Report

One answer

Your answer