How do you access RTC Custom Enumeration List literal values in the Rational Insight warehouse?
We created a Custom Enumeration List in RTC called "Flags".
Normally the literal values and associated names are present in the warehouse REQUEST_ENUMERATION table, but they are not there for the Flags enumeration list. Are they stored someplace else? Does something need to be set in RTC to get them to be updated into the warehouse?
|
One answer
Steve,
We seem to have the same problem. We do not have a link between the Enumeration and the WorkItem (Request). The RIODS.REQUEST table does not have the REQUEST_ENUMERATION_ID as a foreign key as the Enumeration is for custom attributes. Is the workitem linked through another table or does this need to be
Kunal
Comments
Steve Mulligan
commented Apr 10 '14, 12:54 p.m.
A Request can have multiple custom attributes, each with an Enumeration, so the REQUEST_ENUMERATION_ID cannot be in the RIODS.REQUEST table.
|
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.
Comments
As a workaround, an additional field called Test_Flags was added to the process template. For it rather than using the Flag Enumeration List, it used the Flag Enumeration (i.e. single select). The field was then hidden, as we do not want it displayed in the UI. The Rational Insight ETL then brought the enumerated values into the REQUEST_ENUMERATION tabe.
Hi Steve,
Could you please share a bit more details of how you define the additional field "Test_Flags" to be hidden in RTC? Thank you very much in advance!