Create a report from saved data queries that use custom objects
Learn how to create a report from saved data queries that use custom objects
You need to create and save a data query first, and then create a report from it.
To create and save a data query, perform this procedure.
- Navigate to Extension Studio > Data Query in the left navigation menu.
- Click Create New Data Query .
- Enter a SQL query into the text box on the Create Data Query page. Here is a query example of querying data from a custom object named “vehicle”:
SELECT brand__c, model__c FROM default__vehicle WHERE year__c >= 2021 - (Optional) Set the query options. For more information about each query option, see Create new data queries.
- Click Save Query.
- Specify the query name on the Save Query page.
- Click Save.