In Salesforce, we use SOQL to search an organization’s Salesforce data for specific information. Using the SOQL queries, we can also fetch the deleted records from the recycle bin. In this Salesforce tutorial, I will explain how to find deleted records in Salesforce using the SOQL query. Find Deleted Records using SOQL in Salesforce In … Read more >>>
In Salesforce Apex, returning a Map from the SOQL query helps in accessing and handling the data in our Salesforce org. In Salesforce, Map is a data structure that allows you to store key-value pairs, making it easier to fetch records based on specific key values. In this Salesforce tutorial, I will explain all possible … Read more >>>
In Salesforce, we use SOQL (Salesforce Object Query Language) and SOSL (Salesforce Object Search Language) to query, fetch, and search the data of the Salesforce org. To ensure better performance and avoid errors like hitting governor limits, Salesforce has enforced certain limits on SOQL and SOSL queries. In this Salesforce tutorial, I will explain the … Read more >>>
In Salesforce, activities are used to track all the actions and activities we have done with accounts, leads, and contacts related to them in our Salesforce org. In Salesforce, activities have a polymorphic relationship that allows them to relate to other database records, which use two ID fields, WHOID and WHATID. In this Salesforce tutorial, I will explain the … Read more >>>
In Salesforce, validation rules ensure data security by restricting certain data entries or specific business logic when users try to create or update records. In Salesforce, while working with validation rules, we often need to get the list of validation rules to clean up data or to fetch information regarding the validation rules. In this … Read more >>>
Recently, while analyzing sales order data in Tableau, I needed to determine the number of working days it took for each order to be shipped. Subtracting the order date from the ship date wasn’t enough because it included weekends, which don’t count as business days. For this, I used calculated fields to remove weekend dates … Read more >>>
While creating a Sales performance report using Tableau, I wanted to show the Category and Subcategory of the product in the same column. For example, the category “Furniture” was in one column and “Chairs” in another. However, for the report, I wanted them to appear together as a single label, like ‘Furniture-Chairs’. To display both the … Read more >>>
While working on Salesforce records, I need to filter records by matching fields against multiple specified values. To retrieve those records, we use an IN operator/clause in SOQL to fetch the matching field records in Salesforce. In this Salesforce tutorial, we will learn about the IN operator/clause in SOQL(Salesforce Object Query Language). In that, I … Read more >>>
In Salesforce, converting the timezone values is required when working with users and customers from different time zones. With this, we can efficiently handle time-related tasks, such as scheduling meetings, tasks, and deadlines, depending on proper timezone settings. In this Salesforce tutorial, we will learn how to convert TimeZones in Salesforce Apex. Additionally, I will … Read more >>>
In the release of Spring ’24, Salesforce introduced a new feature, the Coalescing Null operator. This operator combines multiple null checks to avoid null pointer exceptions and eliminates the need for multiple if-else conditional blocks. In this Salesforce tutorial, I will explain the Coalescing Null operator in Salesforce Apex and demonstrate how to coalesce null … Read more >>>