It's all about the answers!

Ask a question

Sourcing custom attribute values from database


Xiaoning Dou (653) | asked Oct 18 '10, 9:46 a.m.
edited Apr 18 '13, 4:06 p.m. by Ralph Schoon (63.1k33645)
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!

One answer



permanent link
Geoffrey Clemm (30.1k33035) | answered Apr 18 '13, 3:29 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
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.

Comments
Ralph Schoon commented Apr 18 '13, 4:05 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

For example see: https://jazz.net/library/article/1093 lab 5 how the HTTP Filtered value provider works.


1
Ralph Schoon commented Apr 18 '13, 4:06 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

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.


Ralph Schoon commented Apr 18 '13, 4:09 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

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