Morning I have a conference on salesforce data model and its working to one of our top clients Steel Plant, Visakhapatnam. So I thought that the diagram in PPT I used will help many a lot. Probably it is know to every one. But, it is like a revision for all who are learning salesforce. Try to save […]

1. How many maximum number of aliased fields you can have in Aggregate Query? Ans: 100 2. Can we use Database.QueryLocator for Aggregate Queries?Ans: No 3. Arrange these in appropriate Order: HAVING,WHERE,LIMIT,GROUP BY,ORDER BYAns: WHERE, GROUP BY, HAVING, ORDER BY, LIMIT   4. What is “GROUP BY ROLLUP” and “GROUP BY CUBE” with Example?Ans: GROUP […]

To define a dependent picklist: 1.             Navigate to the fields area of the appropriate object.  For standard objects, from Setup, click Customize, select the appropriate object, and click Fields. For custom task and event fields, from Setup, click Customize | Activities | Activity Custom Fields.  For custom objects, from Setup, click Create | Objects, and […]

Roll-Up Summary Fields While your formula fields calculate values using fields within a single record, roll-up summary fields calculate values from a set of related records, such as those in a related list. You can create roll-up summary fields that automatically display a value on a master record based on the values of records in […]

SOQL Aggregrate Functions1) AVG(): It allow you to roll up and summarize your data for analysis. You can use these 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. Query: Select AVG(Amount) FROM Account where ProjectSite = ‘Mothihari’ 2) […]