Field/Data Usage

[VinceFINET]

Is your feature request related to a problem? Please describe. In parallel of analysing the metadata of the org, I would like to analyse the data, and to know more about if some of my custom fields are being used or not...

Describe the solution you'd like

• First I need to select an SObject in my org (from any package).
• Second I need to select the list of custom fields i am interested in from this object (by default none custom fields will be selected).
• Third I will need to select a start date/time and an end date/time, that range will be used to select the records in the object.
• Fourth in case of large data volume (the number of records can be retrieved from tooling api including deleted ones), you need to specify how will you chunk the data into little bunch of sets.... (is it automatic or not...?? to be defined)
• Then I start retrieving the data (only the selected field with CreatedDate (or LastModifiedDate? TBD)
• RecordTypeId need also to be included because it is important to understand if a field is used only for a specific RT or not.
• The output of the processing should be a table with as many rows as custom fields to analyze, with the total number of rows (whatever the set) where that field is null or empty (and that for each recordtype in the object)

The total number of rows where the fields are empty can also be represented as a percentage with a color if the percentage is lower than XX (threashold TBD)

Describe alternatives you've considered Use another tool outside of OrgCheck.