It's all about the answers!

Ask a question

RTC WI field "Description" in a BIRT Report


MAURO MEDDA (11) | 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 (706) | 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 (706) | 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 (11) | 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.