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

Define Drop-Down list of integers

Hi
I'd like to define an attribute in RTC that consist of drop-down list of  integers, so only one can be selected. (like enumeration, but the values should be integers). The reason is that it needs to export it to excel and do calculations on the selected integers.
How can I do it?
Thanks, Pnina

0 votes



One answer

Permanent link

There is an attribute type Integer that you can use for integers. There is no option to make that a drop down selection. You have to type the integer. 

I do not think Excel cares about the type, it cares a bout the representation. If you want a drop down, you have to use an enumeration. 

If you want to use an enumeration, carefully test on a test machine, what gets exported. I think it is the (string)value of the enumeration.
You can also define an enumeration in a way, where the literal ID is represented by a number, and the display value looks a bit different. In order to get the result like below, you have to define the enumeration literals and then go into the process configuration source to manually modify the enumeration literal ID values to what you desire. As an example look at the built in complexity

    enumeration attributeTypeId="complexity" name="Complexity"
        literal id="1" name="1 pt"
        literal id="2" name="2 pts"

1 vote

Comments

Hi Ralph, 

Thanks for the answer. I'll be more specific about the issue: I'm talking about "Story Points" attribute, the request is to export the related integer value to excel, i.e. 1/2/3/5/8/13/21 to do some calculations for reporting needs.
What is the best way to do it?
Thanks!

Pnina 

I don't understand, why you asked your original question, if you have a totally different question. Have you tried to export to Excel? Maybe you can use macros to remove the PTS in the value? Otherwise my original answer holds and you could create a new complexity attribute of type integer or enumeration and define that without the pts and select it as complexity attribute.

Hi, I finally used your original answer and it worked well. Thank You! 

Then please accept the original answer. 

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: Mar 04, 6:48 a.m.

Question was seen: 590 times

Last updated: Mar 13, 7:59 a.m.

Confirmation Cancel Confirm