RTC WI field "Description" in a BIRT Report

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

3 answers

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Steven Hovater (84●10) | 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 (84●10) | 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

0	permanent link MAURO MEDDA (11●1) \| 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

It's all about the answers!

Related questions

RTC WI field "Description" in a BIRT Report

3 answers

Your answer