Updating or removing existing enum code for dynamic enum type

[rahulverma94]

Hi Experts,

I have a dynamic enum type in items xml with two predefined values:

 <enumtype code="MyEnum" dynamic="true" generate="true" autocreate="false" >
                 <value code="new1"/>
                 <value code="new2"/>
                 </enumtype>


             

What is the best way to remove or update the value code “new2” on runtime?

NOTE: Update/Remove through impex doesn’t work for “new1” or “new2” values.

Regards Rahul

[former_member597493 · Accepted solution]

try this sql query

Delete FROM enumerationvalues item_t0 WHERE (item_t0.code='yourenumValue')