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

import external data on workitem attribute

I need to create a custom attribute on a workitem type.
On my mind the attribute is a ComboBox and the values are the result of a SQL select on an external table (in other words I need an enumeration with dynamic values).
How can I do this?

Thanks in advance. Bye.

0 votes



3 answers

Permanent link
When you say "an external table", do you mean a table in some other database (i.e. not in the RTC repository)? If so, you'll probably want to look at HTTP value set providers:
https://jazz.net/wiki/bin/view/Main/DataSourceValueSetProviders

Cheers,
Geoff

I need to create a custom attribute on a workitem type.
On my mind the attribute is a ComboBox and the values are the result of a SQL select on an external table (in other words I need an enumeration with dynamic values).
How can I do this?

Thanks in advance. Bye.

0 votes


Permanent link
Geoff

thanks for your response. Yes, I mean a table in some other database.
I've checked the information of your link and they're very interested.
A question. Can I use the sql language instead the XML?

Thanks in advance. Bye.

0 votes


Permanent link
To use the pre-defined value set providers, you need to use XML.
But you can implement your own value-set provider (there is some guidance in that wiki article) which is sql based, but that of course would be more work.

Cheers,
Geoff

Geoff

thanks for your response. Yes, I mean a table in some other database.
I've checked the information of your link and they're very interested.
A question. Can I use the sql language instead the XML?

Thanks in advance. Bye.

0 votes

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

Question asked: Mar 28 '12, 2:31 p.m.

Question was seen: 4,771 times

Last updated: Mar 28 '12, 2:31 p.m.

Confirmation Cancel Confirm