Tag: 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

Return Type of SOQL and SOSL Queries in Salesforce

SOQL, or Salesforce Object Query Language, is a query language used to interact with the data stored in Salesforce. It is similar in syntax to SQL, the standard database query language, but is specifically designed for Salesforce data.

SOSL, or Salesforce Object Search Language, is a specialized search language developed by Salesforce for searching text, email, and phone fields across multiple objects simultaneously in the Salesforce environment. Unlike SOQL, which is designed for querying specific objects and fields, SOSL is designed to perform text-based search queries across large datasets and multiple objects at once.

Read More

Salesforce Summer 23 Release | My Top 5 Apex Features

Welcome to the Summer ’23 Release! Salesforce Release is the process by which Salesforce updates its software platform to add new features, enhancements, and bug fixes. Salesforce releases typically occur three times a year, in spring, summer, and winter, and are named after the season in which they are released.

In this blog post, I am going to share a few of my favourite apex features that are coming along with the Summer 23 release.

Read More

How To Secure Apex Code With User Mode Database Operations | Spring 23 Release

Apex code runs in System Mode by default, with elevated access. If you want to run apex code respecting the running user’s permission, now after Spring 23 release, you can do that. With Spring 23 release, Salesforce is bringing the option to execute apex Database and Search methods in user mode instead of default system mode. In this blog post, I will share some examples, but if you prefer to watch videos instead of reading the post, you can do that by watching the video below, which I have published on my Youtube Channel – Technical Potpourri.

Read More
Loading

Archives