Sourcing custom attribute values from database
![]()
Xiaoning Dou (6●5●3)
| asked Oct 18 '10, 9:46 a.m.
edited Apr 18 '13, 4:06 p.m. by Ralph Schoon (63.3k●3●36●46)
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
![]()
Geoffrey Clemm (30.1k●3●30●35)
| 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 For example see: https://jazz.net/library/article/1093 lab 5 how the HTTP Filtered value provider works.
1
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.
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
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.