RETRIEVE, MODIFY, PERSIST – PART 5

Advanced SOSL

We are all familiar with the saying, “with great power, comes great responsibility”. Using SOSL to perform database searches relates to this special developer power: however, this power often comes at a price. To take full advantage of SOSL, we need to understand its limits and core functionalities.

SOSL Limits

I imagine that when Salesforce created SOSL, the engineers looked at each other’s faces and realized that they had just created a mass performance destruction weapon.Continue Reading

RETRIEVE, MODIFY, PERSIST – PART 4

SOSL Basics

As opposed to SOQL, SOSL was specifically designed by Salesforce for developers who know what they want to retrieve, but do not know where it might be found. SOSL stands for Salesforce Object Search Language and it’s the query language Salesforce executes anytime a user calls the global search functionality.Continue Reading

Guy on desk

RETRIEVE, MODIFY, PERSIST – PART 3

Relationship Queries

Relationships. They are such an important part of the human condition, or any type of life for that matter. We start creating relationships the moment we are born, and even before that. Our brain starts developing connections, and sometimes they are very simple connections. Other times, they are very complex.Continue Reading

RETRIEVE, MODIFY, PERSIST – PART 2

Advanced SOQL

In the previous post, we covered the basics of SOQL, the language Salesforce created to retrieve records from your database. Today, we are going to cover advanced features that will redefine the way you code in the Platform.

Multi-Select Picklists

Let’s say you created a custom multi-select picklist in your Contact object called “Affiliation__c” with values “Member”, “Partner”, and “Founder”.Continue Reading

VISUALFORCE: DEPENDENT PICKLISTS

Display the Right Values at the Right Time

A common developer task is to show values that are dependent. We’ve all had cases when we need to pick a State & City or when we are browsing for a new computer and we need to select Brand & Model. In my developer experience, I’ve come to identify two types of dependent picklist in Visualforce: Model-dependent and Model-related.… Continue Reading

APEX: LOOP CYCLES

A Quick Guide on FOR Loops

Apex is Salesforce’s proprietary cloud-based, object-oriented programming language. Let’s break down that a little bit:

  • Apex was built by Salesforce, for Salesforce. You will not be able to write and run Apex outside your Org.
  • Apex is cloud-based. Unlike many other programming languages, you do not need to install any software to start developing in Apex nor will you have to compile it because the platform will take care of that for you.
Continue Reading