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

How do I upload and update a list of Custom Enumeration values?

I need to make a custom enumeration list of active projects here.  We have nearly 5K of them. I want to interface our list of active projects to a custom enumeration list.  Is that possible? If so, what is the best way to do so?

I would like to write a query from our Enterprise Data Warehouse to provide custom Enumeration Lists of cost centers and active project ID's, and make them available to my custom enumeration lists.

0 votes



2 answers

Permanent link
there are really only two ways

in each case, you have to build the list manually

1. use shared projects and put the contents in the process config
   for this process. I used Excel to make the xml text that needs to be pasted into the process config.
   note that YOU need to be careful that a specific project to internal ID stays consistent.

2. do NOT use shared process config and use database storage for enumerations
  I do not know of any api to inject the list of enum entries into the DB in a batch kind of way.

warning.. I personally do not know the impact of 5,000 entries in an enum list on the performance of the UI or system

0 votes

Comments

How would I use the database storage option to define the list of enumeration values? That sounds like my only viable option.

when u create the custom ENUM in the process definition for this project, you select where the data is stored. Note that if you select database, you cannot use shared process config to use the same definition in multiple projects. each project will have a unique database storage area to be maintained



Really, Sam, your post is off topic.

I am trying to locate the tables in the CCM database that contain the enumeration's list of values. Does anyone know that?  I found the parent enumeration in table ccm.[ENUMERATION].[ENUMERATION].IDENTIFIER, but I don't know where the children's records are stored. What table contains them?

you didn't say put into database. you said report on FROM database.

The question is how to interface a value list from  the results of a query that we would like to use to do an insert into the Jazz DB as our list of open projects changes weekly.

showing 5 of 6 show 1 more comments

Permanent link
If you just want to get a list of the active project areas so that you can add one of them to an attribute in a work item, why not just use an attribute of the type "Project Area" or "Project Area List"(if more than one project areas are allowed)? It's simple and straightforward.

Enumerations are sort of "static" and you have to keep maintaining them.

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
× 10,938
× 35

Question asked: Jan 19 '16, 11:45 a.m.

Question was seen: 3,700 times

Last updated: Apr 05 '16, 10:00 p.m.

Confirmation Cancel Confirm