I'm wondering if there is a way to bulk delete controlled values? We have a LARGE number (thousands) of "not used" values due to a huge import. These records were corrected and re-imported however the older unused values still exist and it would take forever to delete them in the UI.
I've looked at the API but there doesn't appear to be a way to delete enumerations. I see I could suppress them in which case they won't show up as an option in the dropdown while editing a record but they'll still show up in the controlled value list. There is an option to update them but that won't delete them.
I"m assuming I could find them in the database and delete them but I'm worried they may be referenced in multiple tables and not quite sure what the ramification of deleting them in the db might have.