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
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.
Next Steps
In addition to the resources linked above, check out these great tutorials to continue learning more about SOQL!
I tried these queries, but errors indicate that List syntax requires the sObjectType like so:
// without an ID, simply specify the object to then derive the sobject type
DescribeSObjectResult describeResult = Account.getSObjectType().getDescribe();
List fieldNames = new List( describeResult.fields.getMap().keySet() );
String query =
‘ SELECT ‘ +
String.join( fieldNames, ‘,’ ) +
‘ FROM ‘ +
describeResult.getName()
;
// return generic list of sobjects or typecast to expected type
List records = Database.query( query );
System.debug( records );
Event then I get an error I’m not sure how to fix:
line 3, col 28. Invalid initial value type Set for List
LikeLiked by 1 person
Hi Tim,
Sorry about that, it seems my blog has stripped out the < and > characters thinking they were HTML tags and not code. Doh!
Will get that fixed shortly.
Thanks,
Doug
LikeLike
Nice. Thanks!
LikeLiked by 1 person