RTC WI field "Description" in a BIRT Report
3 answers
Look in the WORKITEMS_SNAPSHOT.
cheers
Steve
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