Hello everyone! In this post, we’ll explore the Fields() function used in Salesforce SOQL queries. I’ll walk you through its purpose and provide some practical query examples to make the concept clear and easy to grasp. So, let’s dive right in without any delay!

Fields function in SOQL

When working with Salesforce data, writing efficient and maintainable queries is essential. One feature that significantly simplifies querying multiple fields is the FIELDS() function in SOQL (Salesforce Object Query Language). Whether you're a developer, admin, or working with tools like OmniStudio, understanding this function can save time and reduce complexity.

What is the FIELDS() Function?

The FIELDS() function in SOQL allows you to retrieve multiple fields dynamically without explicitly listing each one. Instead of manually specifying every field, you can use predefined categories to fetch them in bulk.

This is especially useful when:

  • You are exploring a new object
  • The schema frequently changes
  • You want to reduce manual effort in query writing

Syntax:
SELECT FIELDS(<type>) FROM ObjectName
The <type> parameter determines which set of fields you want to retrieve.

Types of FIELDS()
1. FIELDS(ALL)
Retrieves all fields—both standard and custom.
SELECT FIELDS(ALL) FROM Account LIMIT 10

2. FIELDS(STANDARD)
Retrieves only standard fields provided by Salesforce.
SELECT FIELDS(STANDARD) FROM Contact

3. FIELDS(CUSTOM)
Retrieves only custom fields created in your org.
SELECT FIELDS(CUSTOM) FROM Opportunity

Limitations and Considerations:

While powerful, the FIELDS() function comes with a few important constraints:

LIMIT is Required with FIELDS(ALL)
To prevent performance issues, Salesforce requires a LIMIT clause when using FIELDS(ALL).
SELECT FIELDS(ALL) FROM Account LIMIT 50

Cannot Be Mixed with Explicit Fields
You cannot combine FIELDS() with individual field names.
SELECT Name, FIELDS(ALL) FROM Account //Not Allowed

Performance Impact
Fetching all fields can be resource-intensive, especially for objects with many fields. Avoid using it in production queries unless necessary.

Tool Compatibility
Some older tools or API versions may not support FIELDS(). Always verify compatibility in your environment.

Examples:


Hope you like this post, for any feedback or suggestions please feel free to comment. I would appreciate your feedback and suggestions.