Select All Fields in SOQL Query

#1MinuteTip #SalesforceSpring21 I love this. In SOQL, you can now query all fields from an object without specifying the field names individually. Just use FIELDS(ALL), FIELDS(STANDARD) or FIELDS(CUSTOM) in SELECT statement 

select all fields in soql query

References & Useful URLs

  • Salesforce Spring ’21 Release Note Article – SOQL

Interested in a Workshop Mastering SOQL?

If you are a Salesforce Admin or Consultant, learning Salesforce Object Query Language (SOQL) can be a huge benefit to you. Using SOQL, you can search your organization’s Salesforce data & metadata for specific information with a simple command. Like “how many Accounts there are in a particular country?” or “how many custom objects are there in my org?”. You don’t need to build reports to find such information, which will take too much time and too many clicks.

If a live online workshop on mastering SOQL will be of interest to you, please register your interest in the form below. The duration of the workshop will be about 2 hours, it will get you started from scratch, contain live demo & explanation, downloadable step-by-step guide with screenshots, quizzes and hands-on exercises.

If we receive enough interest in the workshop, we will let you know once it is launched.

(By submitting the form, you agree to our Terms of Use & Privacy Policy)

2 thoughts on “Select All Fields in SOQL Query”

  1. Using this query one can export the data from Salesforce Inspector up to 200 records. But how to get the data of the remaining records? Because every time you run the query it shows you the same 200 records for that specific object.

    1. Hi Rachna, I am not sure about Salesforce Inspector, but you can use VS Code to run the query and save the output as CSV or JSON. The maximum number of records returned by query is 50,000.

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
Introducing All Access Pass