I have several dozen pick lists created over time. Some are critical and others have been abandoned. I would like a means of seeing where, or at least an integer of how many times, the pick lists are in use.
Are there any options to discover this programmatically?
Thanks!
Well, each field has a pointer to the Pick List, but the Pick List doesn’t have a pointer to the fields being used. So I would have to fetch all the fields in the database that had a Pick List assigned. Then I could display a count or a list of fields that are using the different Pick Lists. Certainly doable, but will increase the size of the database just a bit to store the index of Pick Lists that have fields.
Maybe it could be a utility, then? Meaning: Preferences > Maintenance >
– Find Pick List Usage
– Remove unused picklists
When user closes the utility the information is purged from the db
Or maybe just a segmented control or popup button on the Edit Pick List screen to filter the list based on used or unused Pick Lists.
.
