Understand the error – System.QueryException: List has no rows for assignment to SObject

Description This issue you may encounter in apex class if you have query like this: The following query is not returning any number of records: Lead l = [SELECT Id FROM Lead WHERE Id = : recordId]; The error “List has no rows for assignment to SObject” occurs when query doesn’t return any rows. Possible Reason …

Understand the error – System.QueryException: List has no rows for assignment to SObject Read More »

Bulk Lead Conversion using Apex

Requirement The goal is being able to convert multiple leads into Accounts, Contacts, and Opportunities programmatically. This process utilizes the Database.LeadConvert class, which supports bulk processing to handle multiple leads efficiently. Technical Approach Using Apex for Bulk Lead Conversion Salesforce provides Database.LeadConvert in Apex which gets Lead Id as parameter and convert into Account, Contact …

Bulk Lead Conversion using Apex Read More »

APEX Execution Chain Procedure

Preceding Execution Chains On an APEX application page, I’ve established a straightforward procedure to mimic a possibly longer-running process by utilizing sys.dbms_session.sleep. This procedure doesn’t employ the new Execution Chain; rather, it’s a standard Execute Code process type designed to execute the specified PL/SQL code. The duration of the sleep is determined by the user, …

APEX Execution Chain Procedure Read More »

Bitmap Indexing in Operating Systems

In the domain of database management, efficient data retrieval is crucial. Among the many indexing techniques used to improve query performance, bitmap indexing is especially notable, particularly in data warehousing and analytical processing contexts. This article examines the complexities of bitmap indexing, discussing its structure, implementation, benefits, and applications. What is Bitmap Indexing? Bitmap indexing …

Bitmap Indexing in Operating Systems Read More »