Delete Dropdown List

I need to do some housekeeping on a Sugar instance and this includes removing some redundant customised dropdown lists.

In Studio you are unable to delete DD lists directly.

I am familiar with the language files in custom and also that DD lists are referenced by field definitions in various places (including in the database in fields_meta_data)

Is there a way to manage unwanted dd lists out of the system in a way that maintains integrity.

Otherwise you can end up with a library of DD lists which becomes increasingly difficult to manage over time.

Thanks

Neil

Parents
  • If you instance is OnSite so you are able to:

    • delete the respective dd files from custom/Extension/application/Ext/Language/
    • update the table fields_meta_data in order to replace redundant dd list by some other

    Remember to run Quick Repair and Rebuild.

    Regards

    André Lopes
    Lampada Global
    Skype: andre.lampada
  • Hi André

    Thanks for your quick response

    I followed those steps on a couple of fields and the result was as follows:

    1. Newly named DD list appears in the Dropdown Editor - from the new/renamed language file in custom/Extension/application/Ext/Language/

    2. Correct DD list appears on the field in Studio - following change to Ext1 in fields_meta_data

    3. Old DD list is no longer mentioned in re-merged main language file

    However... the old DD List is still appearing in the Dropdown Editor list in Studio

    QRR was done, otherwise wouldn't have updated re-merged main language file.

    Neil

Reply
  • Hi André

    Thanks for your quick response

    I followed those steps on a couple of fields and the result was as follows:

    1. Newly named DD list appears in the Dropdown Editor - from the new/renamed language file in custom/Extension/application/Ext/Language/

    2. Correct DD list appears on the field in Studio - following change to Ext1 in fields_meta_data

    3. Old DD list is no longer mentioned in re-merged main language file

    However... the old DD List is still appearing in the Dropdown Editor list in Studio

    QRR was done, otherwise wouldn't have updated re-merged main language file.

    Neil

Children