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

Sourcing custom attribute values from database

Questions
Tags
Users
Badges
Xiaoning Dou
(6●5●3) edited
Apr 18 '13, 4:06 p.m.
We'd like to dynamically load values for custom attributes from existing data sources.

Is there anyway to source the enumeration values of a custom attribute from a database table?

Is extending AttributeValueProvider a feasible way to go? Or is there a better way?

On a related topic, I know you can extend the data warehouse database by creating new snapshot tables. But I am not sure whether we can extend the core RTC database with new tables?

Thanks!

0 votes

1 answer
7,309 views
0 votes

One answer

Permanent link
Geoffrey Clemm
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (30.1k●3●34●35) Apr 18 '13, 3:29 p.m.
Starting in RTC-4.0, dynamically loading attribute values from an arbitrary HTTP source is available as "Filtered Value Set":
https://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m2/index.jsp?topic=%2Fcom.ibm.team.workitem.doc%2Ftopics%2Ft_configuring_http_filtered_value_set.html
You can also store enumeration values in the database, allowing for permission-controlled additions to the enumeration values (no project area modification required):
https://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m2/index.jsp?topic=%2Fcom.ibm.team.workitem.doc%2Ftopics%2Ft_defining_priorities_severities.html

WRT extending the data warehouse database, that requires purchasing a license to Rational Insight.

0 votes

Comments
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Apr 18 '13, 4:05 p.m.
For example see: https://jazz.net/library/article/1093 lab 5 how the HTTP Filtered value provider works.

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Apr 18 '13, 4:06 p.m.
Be aware that storing the enumeration values in the database currently does not work if you share a process. There is an enhancement request for that.

1 vote

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Apr 18 '13, 4:09 p.m.
Sigh.... I forgot to mention https://jazz.net/wiki/bin/view/Main/AttributeCustomization also describing how to do attribute customization. Please note you can also create Java extensions for that as described at the end of the page.

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.

Ask a question
Guidelines
FAQ
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
× 11,106

Question asked: Oct 18 '10, 9:46 a.m.

Question was seen: 7,309 times

Last updated: Apr 18 '13, 4:09 p.m.

Confirmation Cancel Confirm