Tag: Dynamic SOQL

Difference Between Count() and Count(fieldName) in SOQL Query

The COUNT() method in SOQL (Salesforce Object Query Language) is used to count the number of records that meet specified criteria. It’s similar to the COUNT() function in SQL and is useful when you need to know the total number of records without retrieving all of them.

In SOQL (Salesforce Object Query Language), the COUNT(fieldName) function is used to count the number of non-null (non-empty) values in a specific field across a set of records. This function differs from the COUNT() function, which simply counts the total number of records.

Read More

Fetch All Fields In SOQL Query | Spring 21 New Feature

If you worked with SQL or any other query language before, you probably familiar with Select * from …, right? This is the way to fetch all fields from a particular table in other(mostly all) query languages. But in the Salesforce world, we were not having this feature. In SOQL, there is nothing with which we can fetch all the fields unless we specifically mention all the field names in the query.

But now in Spring 21, Salesforce is bringing a function through which we can fetch all fields in SOQL Query.

Read More
Loading

Earlier Posts

  • 2024 (32)
  • 2023 (47)
  • 2022 (25)
  • 2021 (35)
  • 2020 (41)
  • 2019 (13)
  • 2018 (16)
  • 2017 (14)
  • 2016 (18)
  • 2015 (74)
  • 2014 (20)