Tag Archives: SOQL

Force.com Performance Profiling Using the Developer Console

Force.com Performance Profiling Using the Developer Console

If you’ve built an application on the Force.com platform, you want to deliver a great experience to your users. But how can you tell if your applications are performing well and will continue to perform well? Using the Developer Console, you can use “performance profiling” to identify and fix performance hotspots, and ensure that your applications are both fast and scalable.

In Blog: engineering | Also tagged , , , | Leave a comment

Force.com SOQL Best Practices: Nulls and Formula Fields

Force.com SOQL Best Practices: Nulls and Formula Fields

Best practices for building Salesforce SOQL queries on large data volumes (LDV) included avoiding filtering on fields with nulls, and formula fields. If you’re implementing new queries—or want to clean up some of the workarounds you implemented prior to the Winter ’13 release—consider these updates related to filtering on nulls and formula fields.

In Blog: engineering | Also tagged , | Leave a comment

SOQL Polymorphism, or How I Learned to Love the Polymorphic Relationship

In Winter ’13, you can now use the SOQL polymorphism feature via the new TYPEOF clause to do complex queries on polymorphic fields in a single call. Read more to learn how this feature can make your queries more powerful, easier to understand, and easier to manage.

In Blog: tech-pubs | Also tagged , , | Leave a comment

Using SOQL to Determine Your Force.com User’s Permissions

Permission sets make salesforce.com admin’s lives easier by assigning permissions to users with more granularity than what a profile already provides. Using SOQL enables admins to view those permission assignments across their user’s profile and permission sets.

In Blog: engineering | Also tagged , , , , | Leave a comment

The Joys of SOQL Pagination

The SOQL Pagination feature is now generally available in Summer ’12. This feature includes the new OFFSET clause used in Salesforce Object Query Language (SOQL) queries. What exactly does OFFSET do, you might be wondering? OFFSET lets you speci

In Blog: tech-pubs | Also tagged , , | Leave a comment

Feel the Power: Developer Console Updates for Summer ’12

The Developer Console is quickly becoming the easiest and most powerful place to work with Apex and Visualforce code. If you haven’t tried it lately, log in to an organization and click Your Name > Developer Console to see how the Developer Con

In Blog: tech-pubs | Also tagged , , , , , , , , , | Leave a comment

Generally Available Features for Force.com Developers in Summer ’12

One of the great things about Salesforce.com’s annual three release schedule is that it allows for piloting and previewing new features before they get rolled out to the general audience.  This allows us to test things out more thoroughly while deve

In Blog: developer-relations | Also tagged , , , | Leave a comment

SOQL Offset in Spring ’12

Spring ’12 is upon us and it comes bearing plenty of gifts for the Force.com developer. One of more important features in Spring ’12 is the addition of the “OFFSET” clause to SOQL. With this clause, you can now paginate through your result set dire

In Blog: developer-relations | Also tagged , , , | Leave a comment

Bulk API Queries

The Spring '11 release introduced bulk queries as a pilot* feature of the Force.com Bulk API 21.0. With this feature, you can submit SOQL queries to Salesforce, run them asynchronously, and then download all your results once the query is com

In Blog: engineering | Also tagged , , , , , , , | Leave a comment

Using Cookbook recipes to solve discussion board posts

Computer-cookie

The cookbook is a great source of answers for many of the common discussion board posts. Take a bite and find out.

In Blog: developer-relations | Also tagged , , , , , , , , , | Leave a comment