Entries in Salesforce (61)


Using Aggregate Functions in SOQL

Up until the release of Salesforce API 18.0 (in Spring '10), SOQL aggregate functions weren't available. Like the ones in SQL, these aggregate functions allow the user to count the number of rows for a specific criteria or MAX/SUM the fields of rows.

When coupled with GROUP BY, the aggregate functions can be particularly handy! check out the example below; the query will return the sum of payment amount for an Account:

AggregateResult[] arTotAmount =[Select Account__c, SUM(Payment_Amount__c) TotAmount from Payment group by Account__c];
Note that a query with an aggregate function returns the results in an array of AggregateResult objects. The AggregateResult object is read-only.

Dreamforce Discount Code


Just got wind that Cloudingo - data deduplication app for Salesforce - is offering $100 off Dreamforce '13 registration using their secret code. Thought I'd share it with you:


Salesforce Spent $10M on This Service

For a price of over $10 million, Salesforce announced last week that it acquired Clipboard, the cross-platform bookmarking service.

"We are extremely happy to announce that has signed an agreement to acquire Clipboard, allowing us to pursue our mission of saving and sharing the Web on a much larger scale. But at the same time we're also sad to see this stage of our adventure com to an end, especially since it means that our relationship with you, our users, will irreversibly change".

Clipboard had accumulated 140,000 users since its launch in January, 2011. Clipboard basically lets users clip search queries, results, maps, images, and videos which can then be annotated and shared.

Consequently, Clipboard said its services will be discontinued starting on July 1st, 2013. I know closing is always sad news, but I'm super excited for my friends at Clipboard. I know they're off to new adventures. Congrats, guys!


Salesforce to Release Communities This Summer

Last week, CRM powerhouse, Salesforce, announced that it will be releasing Communities this upcoming summer; a tool that will allow organizations to create a social portal for their customers.

The issue Salesforce is looking to resolve with Communities, while of course eliminating legacy Social Portal platforms, is to have the ability to bring conversations between organizations and their customers into its site and its apps. In essence, creating collaborative and mobile-ready experiences for business partners and customers all on, and feeding into, Salesforce (Sales, Service, and Marketing platforms).

"You can find a lot of good data on a legacy portal but if you have a question you need to go to a different channel to ask a community of experts....At the other end we have social point solutions on which you can get really good advice from communities, but where you can't get the business data to carry out a transaction."

 Said Michael Peachy, Senior Director of Solutions Marketing for Salesforce. This move by Sales force underlines its continued effort to have Chatter unite business and customer conversations.

It will be interesting to see how useful this platform will prove; especially that a few companies were given access to Communities. Salesforce Communities is said to be priced at $500 per month per community created.


Explore Different Messaging Options in VisualForce (Part 1)

VisualForce offers several options when it comes messages such as a warning of an error. Today, I'm going to explain the key differences between the messaging options in VisualForce:

  • apex: pageMessage is used to display a single custom message using the Salesforce formatting. With this one, you have the option to control and specify the "Severity" (the displaying of the message box) and the "Strength" (size of the box). Check out the below code for an example:

    <apex:pageMessage summary="This is a pageMessage" severity="error" strength="1"/>
  • Another option is to use apex: pageMessages; which is used to concurrently display the custom messages entered by the developer and those generated by Salesforce. See the example in the code below and how it renders:
 <apex:page controller= "TestMessageController">
  <apex:pageMessages />
public class TestMessageController{
    public TestMessageController(){
         ApexPages.addMessage(new ApexPages.Message(ApexPages.Severity.ERROR, 'This is apex:pageMessages'));
         ApexPages.addMessage(new ApexPages.Message(ApexPages.Severity.ERROR, 'This is apex:pageMessages still'));
         ApexPages.addMessage(new ApexPages.Message(ApexPages.Severity.INFO, 'This is apex:pageMessages info'));
         ApexPages.addMessage(new ApexPages.Message(ApexPages.Severity.INFO, 'This is apex:pageMessages warning'));

Use SOQL's OFFSET Clause to Paginate your Visualforce Pages

Before Salesforce Summer '12 was released sporting the OFFSET function pagination feature, developers relied on less efficient methods of paginating. In today's post, I want to explain how the OFFSET technology works.

Click to read more ...


Salesforce Adds "Social Intelligence" for Chatter

Last week Salesforce redefined social intelligence in its enterprise social network: Chatter. With its new "social intelligence" capabilities, the revamped Chatter is aimed at empowering customers and companies by tapping into their interest graph and connecting with stakeholders in entirely new ways.

Click to read more ...


Benioff to Set $1 Billion for "Possible Acquisitions"

Salesforce announced on Monday that it's about to go shopping for acquisitions with $1 Billion that's going to be raised in debt. The plan is to float convertible bonds due in 2018. The proceeds are said to be used for "general corporate purposes, including funding possible acquisitions of, or investments in , complementary business, services or technologies, working capital and capital expenditures."

It's interesting to note that Salesforce made another quite acquisition on February. The acquired company is EntropySoft; a French software company specializes in management of Web content for enterprises. 






About SQQL Select 

Salesforce’s Apex SOQL uses the following Syntax for the SOQL Select statement:

SELECT someField
FROM someObject
WHERE someCondition

Here's some helpful tips on
SOQL’s SELECT statement:

  • The syntax is not case sensitive, for example: SELECT = select.
  • Currently, SOQL statements cannot exceed 10,000 characters, but the good news is that Salesforce has promised to raise the limit to up to 20,000 characters, soon.
  • The result is stored in a result table, called the result-set.
  • Results are generally not ordered unless you use an ORDER BY clause in the query