Is there (what's the most efficient) way to mass delete Global Value Set values?

Removing/Replacing them manually one by one in the UI is not acceptable. I thought I might be able to do it via destructiveChanges with ant, but I am not sure if you can specifically delete certain values and not the whole set.

I also thought about deleting and deploying again, though it's a bit too late as it's referenced by quite a few picklists in the system.

  • Did you want to delete them, or just inactivate them? – martin May 5 '17 at 5:48
  • 1
    Deactivating is easy, I want to delete them – Boris Bachovski May 5 '17 at 5:50
  • I tried to do a destructiveChanges.xml for GlobalPicklistValue. It failed with the message "Entity type 'GlobalPicklist' is not available for delete in this api version". Which is odd considering I was trying to delete a GlobalPicklistValue. – Daniel Ballinger May 15 '17 at 2:02
  • That's confusing. I also had no luck at deleting with destructive changes, waiting on Salesforce support to see what they say – Boris Bachovski May 15 '17 at 2:11

I don't think there is any native way or Solution but when when I done some search I found a Idea mass delete picklist values (setup).Which you can vote.

There I also found a Solution(Hack) which you can use in your use case. From the original Answer.

There is an extension in Google Chrome called "Snap Links Lite." It is a great tool (I use daily anyways). Essentially it allows you to hold right click on the mouse and drag a select box over anything that contains a hyperlink. So, if there are 10 hyperlinks that you want opened in new tabs, instead of manually clicking "open in new tab" this select box will open them for you.

Now, if we use this select box on the "Del" hyperlink of the picklist values, it opens another tab (and for whatever reason overrides the "are you sure" dialog box), and when the original screen is refreshed the picklist values are deleted! All you have to do then is close the tabs opened with snap links. I deleted 40 values in 15 seconds.

Many user successfully use it. Here is a extension link for your help. Which you can try.

Snap Links Lite

  • 2
    This is the correct answer as of Summer '17. You can inactive values through the Metadata API, but the UI is the only way to to delete the picklist values. – TheSFDCTower May 19 '17 at 5:29
  • 1
    I can confirm this, Salesforce support responded with "I believe it is not possible to actually purge the inactive values from a globalValueSet." – Boris Bachovski Jun 14 '17 at 3:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.