Skip to main content

Posts

Showing posts from August, 2013

Aggregate SOQL Functions in SFDC Pros and Cons

"Aggregate query does not support queryMore(), use LIMIT to restrict the results to a single batch"
I was lately working on some reporting requirement on salesforce which was possible only through visualforce and as soon as i heard the business scenario i was confident enough that my solution will be simplified if i stick to the Aggregate Function in SOQL SFDC.
I knew i had huge data in my org and never thought using Aggregate function will lead me to below error
"Aggregate query does not support queryMore(), use LIMIT to restrict the results to a single batch"
This error motivated me to blog this article and share some experience on when to make use of these aggregate query and when not in apex .
If you are confident that the data in a object  can exceed 20000(approximate figure) rows i would prefer avoid these and instead prefer using loops and making page read only at-least and writing my own logic to sum and count .
The read only attribute gives the power to exc…

From Administrator To Advanced administrator of Salesforce CRM and Force.com Applications

Recently salesforce came with BETA exams for the advanced administrator and this provided me an opportunity to clear this exam free of cost.To know more about what BETA exams are and how they can be useful in getting yourself certified please read the below article 

BETA EXAMS KNOWLEDGE ARTICLE

The aim of this blogpost is  to give an idea of what are the areas candidates must go through to gain this valuable certification.Please dont ask for exam dumps or any other material as these are not ethical and also whats the use of attending an exam just by going through dumps .

Please make a habit of going through study guide and make sure you go through all the videos mentioned in the study guide(All videos are  not free and you may need partner portal access to watch .Ask your organisation if they have one ) .Also search for topics mentioned in  study guide in salesforce help and training portal .

Let me ease some task by providing links to the study guide and help and training portal

LATEST ST…