Query all fields(FIELDS()) in SOQL Salesforce - Salesforce Globe For You

Query all fields(FIELDS()) in SOQL Salesforce - Salesforce Globe For You

Solution: FIELDS() can be added in SOQL query to add all/only standard/only custom fields.

FIELDS(ALL) — to select all the fields of an object.

FIELDS(CUSTOM) — to select all the custom fields of an object.

FIELDS(STANDARD) — to select all the standard fields of an object.

Example: Open query editor of developer console and run the query

SELECT FIELDS(CUSTOM) FROM CASE Limit 200

Output:

Note: There are some limitations as of now whether the FIELDS() functions are supported for Bounded and unBounded queries.

Go through the table given in the link below for more details

https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_fields.htm#limiting_result_rows