How to Report on Objects and Fields Defined in Salesforce

At times you may want to have a report on objects and fields defined in your Salesforce Org. You may want this to document the schema definition in your org or for data migration/integration discussion and mapping.

There is an object called ‘Entity Definition that stores information about standard/custom objects. And you can link it to another object called ‘Field Definitionto get details on standard/custom fields defined on that object.

All you need to do is to create a custom report type based on these two objects and use this custom report type as an ingredient in your report. You can then add filters or group by fields or do anything that you can do in a standard report in Salesforce. Your dish is ready.

Here’s a short step-by-step guide which explains this simple process of getting a list of All Objects & Fields in Salesforce in just about 10-15 minutes. Follow this guide to learn how to:

  • Create a Custom Report Type for Metadata
  • Create a Custom Metadata Report
  • View Custom Metadata Report
  • Export Metadata Report

References & Useful URLs

21 thoughts on “How to Report on Objects and Fields Defined in Salesforce”

  1. This is amazing, thank you so much for posting!
    I do have a quick question when I ran this report the field usage column is blank, and no results are displayed. Would you know why this is happening?

    1. Hi Susie, I tried Googling for the use of field usage column but couldn’t find anything relevant. You may want to log a case with Salesforce Support to find out about the same.

      Regards,
      Ashish

  2. Thank you for this! We’re doing a data governance review and this saved me hours of work trying to capture which data is on which objects in Salesforce. This was a lifesaver!

    1. Ashish Agarwal

      My pleasure Alyssa. Happy to note that this saved you hours of work. That exactly is one of the objectives of my blog

  3. If you want to take things to the next level, then Elements.cloud pulls all the metadata from the Org and presents it an easily navigated tree structure

  4. This is great and very helpful! Is it possible to drill down further? I am looking the data type = picklist, and I want to know what the picklist options are. Please let me know if that is clear and if it is possible to do.

    1. Hi Pam,

      We took a look at the custom report type again and created the report. To the best of our knowledge, a further drill down is not possible and the picklist values cannot be fetched in the report.

      Adwait

    1. Hi Jesscia, I think you are referring to page layouts and not case record types as fields are assigned to page layouts and not record types. I did a quick test and don’t think we can show the fields on different page layouts.

  5. Am I correct that “Last Modified Date” on the Field Definition object is derived from the “Modified By” you see on the field itself if you go to Setup – Objects – Fields and Relationships – Select any field – see “Modified By”?
    If yes, then the “Last Modified Date” in this report shows only updates to the field label, field name, API name, data type, help text, description, etc. Not that the field has its value set on this date last time.

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Scroll to Top

Don't Miss Out on New Step-by-Step How To Guides on Salesforce...

…Subscribe to Our Newsletter!