Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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 ???

0 votes

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. 

So, please assign the enumeration itself directly to a new temp attribute and then try your data-load. First the enumeration values have to load into the database and then you can see the associations.

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.

How did you resolve your issue? Maybe it would give me an idea to solve mine.

Thanks in advance.



One answer

Permanent link
Hi Dave, please refer to this article.

0 votes

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

Register or log in to post 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,019

Question asked: May 10 '13, 10:56 a.m.

Question was seen: 6,219 times

Last updated: Sep 10 '13, 3:59 p.m.

Confirmation Cancel Confirm