How do I remove LOV values?

Hi,

I am having difficulty with a LOV element and some duplicate values that I accidentally added and want to remove.

I have tried executing DBUpgrade against the following file

<setup version="2.0">
<cardtypes>
<cardtype element="CTPUBLICATIONOUTPUT">
<fielddefinition>
<cardtypefield element="FPUBLISHKCMARKET" action="remove" />
</fielddefinition>
</cardtype>
</cardtypes>
<fields>
<field element="FPUBLISHKCMARKET" action="delete" />
</fields>
<lovs>
<lov element="DKCMARKETPLACE" action="delete" />
</lovs>
</setup>

but got error saying 

The field "FPUBLISHKCMARKET" on the card type "CTPUBLICATIONOUTPUT" still has values, so it cannot be removed.

How do I delete the values associated with the LOV so that I can then delete it?

Any advice appreciated,

Regards,

Ann

emoji
Parents Reply Children