Search results
Use the FIELDS() keyword in the fieldList to select groups of fields without knowing their names in advance. This keyword simplifies SELECT statements, avoids the need for multiple API calls, and provides a low-code method to explore the data in your org.
You can use FIELDS() as the complete field list. For example: SELECT FIELDS(ALL) FROM Account LIMIT 200 SELECT FIELDS(CUSTOM) FROM Account LIMIT 200 SELECT FIELDS(STANDARD) FROM Account
SOQL SELECT Syntax. SOQL query syntax consists of a required SELECT statement followed by one or more optional clauses, such as TYPEOF, WHERE, WITH, GROUP BY, and ORDER BY. The SOQL SELECT statement uses the following syntax: SELECT fieldList [subquery][...] [TYPEOF typeOfField whenExpression[...] elseExpression END][...] FROM objectType[,...]
SOQL SELECT Examples. The following are examples of text searches that use SOQL. Type of Search. Examples. Simple query. SELECT Id, Name, BillingCity FROM Account. WHERE. SELECT Id FROM Contact WHERE Name LIKE 'A%' AND MailingCity = 'California'. ORDER BY.
There is no way to Select * with SOQL. You can however work-around this limitation by using dynamic SOQL and describe methods to get all of the fields on the object. This is described in detail in this post by Cory Cowgill:
2 wrz 2024 · How to Select All Fields in SOQL. Contrary to SQL, SOQL does not have a straightforward SELECT * syntax to select all fields of an object. Instead, you need to explicitly specify the fields...
19 sty 2021 · 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.
