My org has been around for quite a while and some admins were more meticulous than others about cleaning up old single- and multi-select picklist values.

Well, I'm one of the more-meticulous sort and I'd like my users to have clean data.

Is there a pre-existing way to go through my org, picklist field by picklist field, and find out which values are in records and no longer in the metadata, and then figure out how to fix them? I can easily write the Batchable class, but it seems like someone else already has.

  • 3
    I assume you are talking about records with Picklist values no longer in the metadata? – cropredy Aug 18 '16 at 22:06
  • @cropredy yes, that. – Charles Koppelman Aug 21 '16 at 23:02
  • 2
    I suppose you could make the picklists 'restricted', then use Data Loader to run an update and find out which records are in error to get a sense of the scale of the problem – cropredy Aug 22 '16 at 1:06
  • @cropredy I don't think you can change a picklist to/from restricted as of Summer '16. Also, wouldn't that cause massive errors in production? – Charles Koppelman Aug 22 '16 at 15:19
  • Ah yes, a good point. Full copy sandbox would be the way but if summer 16 restricted this then this idea is a NOP – cropredy Aug 22 '16 at 15:22

Easiest way would be to run a report with the filters having a picklist not equal to then your list of values you want to keep. You may be able to just go to the printable view of the values and copy/paste them. Then export the report. Make sure you grab the ID's so you can easily update with the data loader. Use Excel to make any updates you need.

  • This does not work for multiselects, which are included in my data – Charles Koppelman Aug 22 '16 at 15:20
  • Also this is so far from automated, that it's very error-prone. Especially if users change data between when I run the report and when I upload it. – Charles Koppelman Aug 22 '16 at 15:22

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.