It's all about the answers!

Ask a question

RTC WI field "Description" in a BIRT Report


MAURO MEDDA (111) | asked Dec 01 '16, 4:40 a.m.
 Is it possible to get the RTC WI field "Description" in a BIRT Report?

3 answers



permanent link
Steven Hovater (10920) | answered Dec 01 '16, 5:52 a.m.
 It's in the WORKITEM_EXTRA_DATA table. You'll need to work from the workitem itemId.

cheers
Steve

Comments
MAURO MEDDA commented Dec 01 '16, 6:23 a.m.

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
Steven Hovater (10920) | answered Dec 01 '16, 9:15 a.m.
 Look in the WORKITEMS_SNAPSHOT.

cheers
Steve

Comments
MAURO MEDDA commented Dec 02 '16, 7:36 a.m.

Hi Steven,

  no way to find the  WORKITEM_EXTRA_DATA table in the WORKITEMS_SNAPSHOT on the RTC 6.0.2 version.


Steven Hovater commented Dec 02 '16, 11:49 a.m.

 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?




MAURO MEDDA commented Dec 05 '16, 5:11 a.m. | edited Dec 05 '16, 5:20 a.m.

 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
MAURO MEDDA (111) | answered Dec 14 '16, 12:11 p.m.
 The workitem "Description" field is under the table WORKITEM_EXTRA_DATA from the WORKITEM_SNAPSHOT with Jazz simple Data Set style

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.