Category Archives: Admin

Aggregate Functions in Salesforce Visualforce page

Use aggregate functions in a GROUP BY clause in SOQL queries to generate reports for analysis. Aggregate functions include AVG(), COUNT(), MIN(), MAX(), SUM(), and more. You can also use aggregate functions without using a GROUP BY clause. For example, you could use the AVG() aggregate function to find the average Amount for all your opportunities. Example SELECT AVG(Amount)FROM Opportunity GROUP BY clause is used in SOQL query to… Read More »

Lead and Case assignment rules in Salesforce

What is an Assignment Rule? Assignment Rules are used to assign Leads and Cases automatically to the assigned users based on criteria. There are two types of Assignment Rules in Salesforce they are  Lead Assignment Rules and Case Assignment Rules. What is Salesforce lead assignment rules? Salesforce lead assignment rules defines the administrators to assign a lead to users and… Read More »

Map in Salesforce

Map It is key value pair. Key must be primitive data type and value may be primitive data types/Reference data type. Primitive data type are integer,decimal,string,id,Boolean,data… Only one key value is allowed to be null. Syntax Map<key,value> variablename = new map<key,value>(); Data is storing according to keys dictionary order. keys are case sensitive Methods Put(key,value);… Read More »

Set in Salesforce

Set It doesn’t allow duplicates. It maintains dictionary order. Set maintains hash code mechanism. It allows only one null value. Syntax set<Datatype> variable name = new set<Datatype>(); Methods Add(Element); addAll(list/set s); contains(Element); containsAll(set/list s); size(); clear(); remove(Element); Share this…Facebookemail

List in Salesforce

List It allows Duplicate values . It maintains insertion order. List maintains index based. It allows multiple null values. Syntax List<Datatype> variable name = new List<Datatype>(); Examples List<integer> a = new List<integer>(); List<Account> b = new List<Account>(); List<integer> ages;  Ages = new List<integer>(); List<integer> ages = new List<integer>(){20,30,50}; Methods available in List add(Element); add(index,Element); addAll(list… Read More »

Custom settings in Salesforce

What is custom setting? Custom setting is also used to store the data, but the data which is stored here can be retrieved without writing a soql query. As if we retrived data without writing soql query then performance will be faster They are 2 types of custom settings, they are :- List custom setting… Read More »

DML in Salesforce

DML stands for Data Manipulation Language. Where we want to manipulate the data in the sObject we will use Dml. Types of DML operations INSERT UPDATE UPSERT DELETE UNDELETE MERGE Dml can be performed in 2 formats 1. Using  keywords (insert,update,delete,undelete,merge,upsert)(used as for Atomic operation) 2. Using predefined apex class database. (used as for Atomic… Read More »