Swapnil SFDC | Salesforce

What is Salesforce Object Query Language (SOQL) in APEX ? SOQL means Salesforce Object Query Language which is to query the records from the database.com based on the requirement.  Apex has direct access to Salesforce records that are stored in the database, you can embed SOQL queries in your Apex code and get results in a straightforward fashion. When SOQL is embedded in Apex, it is referred to as inline SOQL. To include SOQL queries within your Apex code, wrap the SOQL statement within square brackets and assign the return value to an array of sObjects. For example, the following retrieves all account records with two fields, Name and Phone, and returns an array of Account sObjects. Use SOQL when you know which objects the data resides in, and you want to: Retrieve data from a single object or from multiple objects that are related to one another. Count the number of records that meet specified criteria. Sort results as part of the query. Retrieve data from number, date, or che...

What is Object Relationships in Salesforce Object relationships are a special field type that connects two objects together. Salesforce Object relationships is nothing but a two way association between two Objects. One Object record information is linked in another object record. In Salesforce.com, Object Relationships is created between two Object. Here the custom field of an Object record contains a link in another object record. To build many custom object in Salesforce.com, relationships plays a major role. Let’s think about a standard object like Account. If a sales rep opens an account, they’ve probably been talking to a few people at that account’s company. They’ve probably made contacts like executives or IT managers and stored those contacts’ information in Salesforce. It makes sense, then, that there should be a relationship between the Account object and the Contact object. When you look at an account record in Salesforce, you can see that there’s a section for contacts on t...

What is DML in Apex ?  Data Manipulation Language (DML)    Create and modify records in Salesforce by using the Data Manipulation Language, abbreviated as DML. DML provides a straightforward way to manage records by providing simple statements to insert, update, merge, delete, and restore records. # DML Statements: The following DML statements are available. insert update upsert delete undelete merge Each DML statement accepts either a single sObject or a list (or array) of sObjects. Operating on a list of sObjects is a more efficient way for processing records. All those statements, except a couple, are familiar database operations. The upsert and merge statements are particular to Salesforce and can be quite handy. The upsert DML operation creates new records and updates sObject records within a single statement, using a specified field to determine the presence of existing objects, or the ID field if no field is specified. The merge statement merges up to three records...

Salesforce Collections: List, Set, Map Collections are the group of similar types. There is no limit on the number of items a collection can hold. However, there is a general limit on heap size. There are three types of Salesforce collections. List Set Map 1. List: List is an ordered collection of elements which will allow duplicates. A list is an ordered collection of typed primitives SObjects, user-defined objects, Apex objects or collections that are distinguished by their includes. The index position of the first element in a list is always '0' List elements can be of any data type: primitive types, collections, sObjects, user-defined types, and built-in Apex types. A list is an ordered collection of elements that are distinguished by their indices. To declare a list, use the list. keyword followed by the primitive data, SObject, nested list, map, or set type within < >characters. List Syntax: List<datatype> listName = new List<datatype>(); Note:-  Simil...