Documentum/DQL: alter type to add/drop an attribute's value assistance etc.
Sample:
ALTER TYPE hrd_document MODIFY (hrd_team_name (VALUE ASSISTANCE IS LIST (
'global',
'cnb_emea',
'con_mgt',
'comm_kit',
'policies',
'hr_empl_rels'
)
IS COMPLETE));
ALTER TYPE hrd_document MODIFY (hrd_team_name (MAPPING TABLE (
VALUE='global' DISPLAY='Global',
VALUE='cnb_emea' DISPLAY='C&B/EMEA',
VALUE='con_mgt' DISPLAY='Content Management',
VALUE='comm_kit' DISPLAY='Gbl HR Communications',
VALUE='policies' DISPLAY='Gbl Policies',
VALUE='hr_empl_rels' DISPLAY='hrExchange : Employee Relations'
)));
?
Values in mapping table should be value from value assistance.
?
Drop:
When you dropped the value assistance for the attribute you should also have dropped the value mapping table
ALTER TYPE your_typeMODIFY (your_attribute (DROP MAPPING TABLE)) PUBLISH
ALTER TYPE your_typeMODIFY (your_attribute (DROP VALUE ASSISTANCE)) PUBLISH
