How do I upload and update a list of Custom Enumeration values?
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.
2 answers
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
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
The below two posts may be of interest.
https://jazz.net/forum/questions/179659/is-it-possible-to-automatically-sort-enumeration-literals-from-a-z
(take note of Ralph's comments about thousands of enumerations)
https://jazz.net/forum/questions/172599/how-can-i-create-enumeration-literals-without-being-able-to-modify-the-process-specification
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.
Enumerations are sort of "static" and you have to keep maintaining them.