Skip to Content, PHP, MySQL, Javascript, Ajax, Htacces

SOQL Features

by June 1, 2012 SOQL

div dir=”ltr” style=”text-align: left;” trbidi=”on”>

Group by feature:
May some of you are aware with Group by having count in SFDC. However I am going to share the same here.
We have very good thing is Group By having count. We can put the count to filter the records. My requirement is that if email is duplicates in contact’s record then I need to viagra pfizer exclude those records.
Here is cialis viagra levitra online the code for that, may it will help you too.
AggregateResult[] groupedResults = [Select Email from Contact where email’ group by Email having count(Email)<2];
Was trying something and came out with an interesting fact which can cialis generic save us best over the counter viagra SOQL viagra samples queries.
Salesforce Object initialization feature:
Up till now the process to update any object was to first query that object using its Ids, and than we used order viagra online to buy cialis canada update that list.
Now if we are having buy cialis Id of the object than we need not do any SOQL. For ex-
Opportunity temp = new Opportunity(id = '0063000000Xh92q');'Test Update';
update temp;
This code will update the opportunity with Id=’ '0063000000Xh92q'’. Using this approach cheap cialis soft cost online we can save many SOQL queries.