Adding enumerations in database table
![]()
Hi,
when we add some custom enumerations in project area, we can choose whether it will be stored in PA process or database.
If we choose database, these enumerations are not visible in PA process configuration source, right?
So, there are stored in RICALM.REQUEST_ENUMERATION table, right?
My question is next:
Can I add more literals to this enumeration through this table, not via Project Configuration, so these new literal can be visible in Project Configuration or on work item which use this enumeration?
Regards,
|
One answer
![]()
Ralph Schoon (63.3k●3●36●46)
| answered Mar 28 '13, 5:18 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER edited Mar 28 '13, 7:46 a.m.
Hi Milan,
you should not attempt to modify the database directly at all, as far as I know. Unless support tells you so, the DB should be off limits to direct modification, unless you want to potentially get yourself into serious trouble. If you want to modify things use the UI and the API if necessary. The UI and API go through the applications persistence layer that knows how to manage things and in which (potentially multiple) locations changes need to be made to be consistent. With respect to the DB backed Enumerations, please be aware that they currently don't take part in process sharing and unless this is addressed in future versions, you need to consider this shortcoming. Comments There are some DB maintenance activities that might be exceptions to the rule not to modify the database.These don't modify the data in the database but metadata that is used by the DBMS to access and organize the database more efficient. Again, be careful, because some actions might have also a bad effect on performance.
|
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.