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

RTC WI field "Description" in a BIRT Report

 Is it possible to get the RTC WI field "Description" in a BIRT Report?

0 votes



3 answers

Permanent link
 It's in the WORKITEM_EXTRA_DATA table. You'll need to work from the workitem itemId.

cheers
Steve

1 vote

Comments
I'm using RTC 6.0.2.  WORKITEM_EXTRA_DATA was within the COMMON_SNAPSHOT, but no more on the RTC 6.0.2 version. Do you kwow where I can found it on the RTC 6.0.2 version? Thank you  Mauro


Permanent link
 Look in the WORKITEMS_SNAPSHOT.

cheers
Steve

0 votes

Comments
Hi Steven,   no way to find the  WORKITEM_EXTRA_DATA table in the WORKITEMS_SNAPSHOT on the RTC 6.0.2 version.

 Baffled. I see it in my 6.0.2 installation. So, you've created a data source to the WORKITEMS_SNAPSHOT, and now you're trying to create a data set.. what tables do you see in the dataset?

 Hi Steven,   this is the list of tables from data source WORKITEMS_SNAPSHOT: APPROVAL APPROVAL_DESCRIPTOR APPROVAL_STATE APPROVAL_TYPE CATEGORY COMPONENT DELIVERABLE LIVE_TIMESHEET_ENTRIES LIVE_WORKITEM_CNT NEW_WI_COUNT PRIORITY REQUEST_STATUS RESOLUTION SEVERITY STATE TYPE WC_BIGDECIMAL_EXT WC_BIGDECIMAL_EXT_FROM WC_INT_EXT_TO WC_ITERATION_EXT WC_ITERATION_EXT_FROM WC_ITERATION_EXT_TO WC_LARGE_STRING_EXT WC_LARGE_STRING_EXT_FROM WC_LARGE_STRING_EXT_TO WC_LONG_EXT WC_LONG_EXT_FROM WC_LONG_EXT_TO WC_MEDIUM_STRING_EXT WC_MEDIUM_STRING_EXT_FROM WC_MEDIUM_STRING_EXT_TO WC_PROJECT_EXT WC_PROJECT_EXT_FROM WC_PROJECT_EXT_TO WC_RELEASE_EXT WC_RELEASE_EXT_FROM WC_RELEASE_EXT_TO WC_REQUEST_EXT WC_REQUEST_EXT_FROM WC_REQUEST_EXT_TO WC_RESOURCE_EXT WC_RESOURCE_EXT_FROM WC_RESOURCE_EXT_TO WC_STRING_EXT WC_STRING_EXT_FROM WC_STRING_EXT_TO WC_TEAM_EXT WC_TEAM_EXTFROM WC_TEAM_EXT_TO WC_TIMELINE_EXT WC_TIMELINE_EXT_FROM WC_TIMELINE_EXT_TO WC_TIMESTAMP_EXT WC_TIMESTAMP_EXT_FROM WC_TIMESTAMP_EXT_TO WC_BIGDECIMAL_EXT WI_BOOL_EXT WI_INT_EXT WI_LARGE_STRING_EXT WI_LONG_EXT WI_MEDIUM_STRING_EXT WI_STRING_EXT WI_TIMESTAMP_EXT WI_TYPE_BINDING WORKITEMS WORKITEM_AGING WORKITEM_AGING_TRENDS WORKITEM_CHNGS WORKITEM_CHNGS_FROM WORKITEM_CHNGS_TO WORKITEM_DAYS_IN_STATE WORKITEM_STATES WS_BIGDECIMAL_EXT WS_BOOL_EXT WS_CATEGORY_EXT WS_COMPONENT_EXT WS_DOUBLE_EXT WS_FLOAT_EXT WS_INT_EXT WS_ITERATION_EXT WS_LARGE_STRING_EXT WS_LONG_EXT WS_MEDIUM_STRING_EXT WS_PROJECT_EXT WS_RELEASE_EXT WS_REQUEST_EXT WS_RESOURCE_EXT WS_STRING_EXT WS_TEAM_EXT WS_TIMELINE_EXT WS_TIMESTAMP_EXT


Permanent link
 The workitem "Description" field is under the table WORKITEM_EXTRA_DATA from the WORKITEM_SNAPSHOT with Jazz simple Data Set style

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
× 11,110

Question asked: Dec 01 '16, 4:40 a.m.

Question was seen: 5,766 times

Last updated: Dec 14 '16, 12:11 p.m.

Confirmation Cancel Confirm