It's all about the answers!

Ask a question

How to add Columns in a table when using BIRT in RTC3.0


Guo Feng Xie (15179) | asked Jun 28 '13, 1:08 a.m.
In WORKITEMS_SNAPSHOT:  WORKITEM_STATES table: has a Column named "TYPE_ID", Then In WORKITEMS_SNAPSHOT:  LIVE_WORKITEM_CNT table doesn't have.

May I ask how could I add this column "TYPE_ID" to that table? Thanks a lot.

Accepted answer


permanent link
Dinesh Kumar B (4.1k413) | answered Jun 28 '13, 3:54 a.m.
JAZZ DEVELOPER
WORKITEMS_SNAPSHOT:  LIVE_WORKITEM_CNT has WI_TYPE which gives the name of the Type instead of the id given by WORKITEMS_SNAPSHOT:  WORKITEM_STATES TYPE_ID

So, if you need is to get the TYPE_ID along with other fields from LIVE_WORKITEM_CNT, you could try creating a Joint Data Set over individual Data Sets representing LIVE_WORKITEM_CNT and WORKITEM_STATES joined over WI_ID

Then the Joint Data Set could be used for the report.  Hope it helps.
Guo Feng Xie selected this answer as the correct answer

Comments
Guo Feng Xie commented Jul 03 '13, 4:50 a.m.

Hi Dinesh.
Thanks for your answer.

Would you pls help answer this question ? thanks a lot
https://jazz.net/forum/questions/117960/cant-find-out-data-by-team-area-name-parameters-when-using-birt-rtc30

One other answer



permanent link
Krzysztof Kaźmierczyk (7.5k480103) | answered Jun 28 '13, 2:51 a.m.
Hello Guo,
You cannot do it manually. If you need these tables, feel free to open new enhancement on jazz.net: https://jazz.net/jazz/web/projects/Rational Team Concert#action=com.ibm.team.workitem.newWorkItem&type=enhancement This might be implemented in furter RTC version then.

Comments
Guo Feng Xie commented Jul 03 '13, 4:48 a.m.

Hi Krzysztof
I accepted below answer as this case. Thanks all the same.

and May I pls help me answer this question ? Thanks a lot.
https://jazz.net/forum/questions/117960/cant-find-out-data-by-team-area-name-parameters-when-using-birt-rtc30

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.