Sunday, March 28, 2010

SOQL: Improvements

How many of you have faced problems understanding the basic difference between Object relationships (as provided by Salesforce.com) and Table/entity Relationships (as provided in conventional RDBMS)?
I am sure many of you must have faced the same problem, at least I did. But lately there are some new enhancements in SOQL which narrows down these differences. For e.g now in SOQL you can have INNER JOINS and you can group data using the famous GROUP BY clause.

So, what is the big deal?

Well, yeah it’s not a big deal that you can
- do more in SOQL and remove your earlier code using which you used to retrieve data in case of INNER JOINS
or
- group your data using GROUP BY clause and have conditions on it using HAVING clause
or
- use some new Date functions in your SOQL query to filter your data (which you used to do using Apex code).

So, in all it means richer SOQL and lesser use of Apex for these purposes.

Interested, then checkout a very good article written by Dr. Umit Yalcinalp
http://wiki.developerforce.com/index.php/A_Deeper_look_at_SOQL_and_Relationship_Queries_on_Force.com

Saturday, March 6, 2010

Salesforce New User Interface Theme: Personal Review











Following are Steps to switch ON the new theme:-
1. Go to Setup
2. In App Setup section go to Customize> User Interface
3. Check "Enable New User Interface theme"
4. Click on Save (Click ok on confirmation box).

Tadaa!!! the new theme is ON, but you would be able to see it only when you click on any tab


As anybody else would be, I myself was too much excited about it as it was long due. But with all the high expectations, I must say that the final outcome is not so exciting. As far as what I have seen, its just a change from the CSS perspective. The only advantage I see is that there is lesser use of images and more use of CSS, which would help pages to get loaded faster. Apart from that everything else seems to be the same. Strangely, Setup section is still in the old theme and has not been upgraded to new theme.

Just a suggestion for SFDC team, we are looking out for more rather than the slight changes in CSS.

Popular Posts