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