In Salesforce, relationships between objects can be defined as either master-detail or lookup relationships, and using SOQL, we can query the details of the child records, such as the record count of child records. In this Salesforce tutorial, I will explain how to query and count child records in Salesforce SOQL. SOQL Queries for Child … Read more >>>
We used SOQL(Salesforce Object Query Language) to retrieve the data from the Salesforce database according to the specified conditions and objects. These objects can be both standard and custom. Similar to all Apex code, SOQL is also not case-sensitive. SOQL is also used in Apex to query Salesforce data stored in the database. In this … Read more >>>
In Salesforce development, test methods don’t support web service callouts by default, and tests that perform web service callouts fail. When testing Apex code that makes HTTP callouts, Salesforce imposes restrictions that prevent actual callouts from being made in a test environment. To bypass this limitation, we can create a mock callout. Mock callouts allow … Read more >>>
As a Salesforce Developer, you want to retrieve records from the Salesforce object, and the results should display like each page of the portal displays 10 records, and we can navigate through pages to view more results using SOQL in Apex. For that, we have different clauses that have the functionality to fetch records in … Read more >>>
In Salesforce SOQL, using a for loop within a for loop is a common approach to process and manipulate records efficiently. Using a for loop, we can iterate over the query results and apply logic directly to each record. In this Salesforce tutorial, I will explain how to create a for loop to iterate through … Read more >>>
In Salesforce Object Query Language (SOQL), when we want to apply any condition in the query, we use the WHERE clause, and we can apply logic there. The HAVING clause is also used to apply conditions in the query, but we can use the HAVING clause in SOQL when we filter results that aggregate functions … Read more >>>
Recently, I was creating a sales report using Tableau. In this report, I needed a simple way to compare Sales, Profit, and Quantity across different product categories. Using a bar chart, it was possible to show the trends, but I would like to display the data with the dimension name and measure values, similar to … Read more >>>
In Salesforce, we have a feature that allows us to track the changes made to fields through field history tracking. We can retrieve the details of the field in Salesforce Relationship Queries in SOQL to obtain the details of changes in the object’s field values. In this Salesforce tutorial, I will explain how we can track … Read more >>>
While working with agents in Salesforce, there are various types of agents with distinct capabilities. We can only deploy some of them in the Salesforce org so that Salesforce users can use them, while others can be deployed on external sites, such as community sites, for external or end users. In this Salesforce tutorial, we … Read more >>>
While creating the job application form in Salesforce, I need to add a validation so that if the applicant selects the “Certification Done” checkbox, they must also provide details in the “Certificate” field. This ensures that applicants who have completed a certification must enter the certificate name or details before saving the record. The validation … Read more >>>