Skip to Content

TheBlogReaders.com

Salesforce.com, PHP, MySQL, Javascript, Ajax, Htacces

SOQL Advance Features

Closed
by June 1, 2012 SOQL
1. Group by feature:
Salesforce Developers are the aware of with “GROUP BY” word in SQL (Stucture viagra Query Language)/SOQL (Salesforce Object Query Language). This key word returns viagra price count of records which are selected.
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 exclude those records. Following is the code for that, may it will help you too.
SOQL Code:
AggregateResult[] groupedRs = [Select c.Email from pharmacyonline-viagra.com Contact how long does viagra last c where email =emailed@gmail.com’ viagra coupon group by Email having count(Email)<2];
Description:
As above SOQL checks the email address and natural viagra substitutes group by Email field count is less than 2. So using the above SOQL we could checks viagra vs cialis how much records are fetching in result set.
2. Salesforce Object initialization feature:
Up till now process to update any sobject was to first query that object using its Ids, and than we used to update that list.
Now if we are having Id of sobject than we need viagra dosage not do any SOQL. For over the counter viagra ex-
Code:
Opportunity tempObj natural viagra = new Opportunity (id = ‘0063000000Xh92q’);
tempObj.name=’Test 123′;
Update tempObj;
Description:
This http://cialis-canadapharmacy.com/ above code will cialis generic update opportunity with Id=’ ‘0063000000Xh92q’’. Using this approach we can save many SOQL queries.

cheap levitra brand cost online

(457)

Previous
Next