How does one report on enumerated custom attributes in RTC with Insight
![]()
I can not find the data for enumerated lists that is for multi-select custom attributes in the data warehouse. I can find and create reports for enumerated types but not the enumerated list type. I have run the RTC_WorkitemEnumeration3 (only job I could find to deal with enumerations) manually and none of the attributes for the multi-select enumerations show up in the query.
Is there something I am missing or is this not supported ???
|
One answer
![]()
Hi Dave, please refer to this article.
Comments I think 4.0.2 and 1.1.1.1 already have this and everything works fine for enumerated type attributes. It only does not work if you make the attribute an enumerated list which allows you to select multiple values. ahh I missed the "list" and couldn't guess the version. I might give a try and post back if I can figure out.
|
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
It will not appear as its not directly tagged to any attribute. Try mapping the enumeration to some temp attribute and then run ETL Job to check if enumeration gets updated.
I have the enumerated list assigned to an attribute and have some workitems using them but we can not find them in the data warehouse - we are using clm 4.0.2 and Insight 1.1.1.1 by the way
Multi-select list is formed by assigning the enumeration at the presentation level. So the enumeration does not get detected as a change for the load.
I tried that and it did not work - I guess it is a bug
David, I found out that the enumeration list values are stored in the query subject "REQUEST_STRING_M_EXT". But they are concatenated on a single string. I'm having trouble to join this with the enumeration query subject to get the description name.