In the Spring ’21 release, you can now select all fields more easily using the FIELDS() keyword. The approach in this blog post is preserved for historical reference.

SOQL is Salesforce’s object query language. It has familiar basic syntax to traditional database SQL syntax but with some noticeable differences. One of the biggest differences is that SOQL does not support wildcard in SELECT statements to query all fields from an object. For example, “SELECT * FROM object”. However, there is a workaround by using Dynamic SOQL and Apex Describe.

In the below example I show you how to query all fields from an object by exploiting the metadata available from the DescribeSObjectResult class.

Example 1: Query All Fields for a Known Record ID

View gist.


ID recordId = '5001a00000CgCE2';
DescribeSObjectResult describeResult = recordId.getSObjectType().getDescribe();
List<String> fieldNames = new List<String>( describeResult.fields.getMap().keySet() );
String query =
' SELECT ' +
String.join( fieldNames, ',' ) +
' FROM ' +
describeResult.getName() +
' WHERE ' +
' id = :recordId ' +
' LIMIT 1 '
;
// return generic list of sobjects or typecast to expected type
List<SObject> records = Database.query( query );
System.debug( records );

view raw

query-by-id

hosted with ❤ by GitHub

Example 2: Query All Fields for All Records

The same concept as above but we don’t have a specific record ID, so we need to determine the sobjectype by explicitly specifying the object we’ll query on.

View gist.


// without an ID, simply specify the object to then derive the sobject type
DescribeSObjectResult describeResult = Account.getSObjectType().getDescribe();
List<String> fieldNames = new List<String>( describeResult.fields.getMap().keySet() );
String query =
' SELECT ' +
String.join( fieldNames, ',' ) +
' FROM ' +
describeResult.getName()
;
// return generic list of sobjects or typecast to expected type
List<SObject> records = Database.query( query );
System.debug( records );

view raw

query-by-sobject

hosted with ❤ by GitHub

Next Steps

In addition to the resources linked above, check out these great tutorials to continue learning more about SOQL!