Skip to main content

Why should I use SOQL?

You need data, fast!
Anyone can SOQL!
Whether it's exporting a csv or answering a question, SOQL can get you the result much faster than creating a Salesforce report.

My top 3 reasons to use SOQL are:
  1. Get data fast
  2. Get answers fast
  3. Flexible access

Get Data Fast

How often do you find yourself making a throwaway report to check what is happening in the system? For example, you updated your Lead routing and want to see if it's been assigning Leads as you expect. Well you could make a report, run it and review the results. Or you could run a SOQL query.

The benefits of running a SOQL query in this case is that you can retrieve different data sets much quicker. In a Salesforce report, you are stuck with the Report Type you selected when creating the report. With SOQL, you can traverse object relationships in a much more natural way.

Get Answers Fast

Have you ever been in a meeting and someone asks a data question that no one has the answer to? Well SOQL comes in handy here because you can run a quick query and get the answer, fast!

Plus, you look like a real Salesforce wiz 😎

Flexible Access

I primarily use 2 different tools to execute SOQL queries:
  1. SFDX Command Line Interface via the sfdx force:data:soql:query command
  2. Illuminated Cloud execute anonymous SOQL Query interface
I'm a big fan of running queries right from the command line because I don't have to load up a web browser or another application. But if I'm in the middle of development or need the intellisense to tell me what the field names are, Illuminated Cloud comes to the rescue.

If you're not familiar with these tools, I highly recommend to check them out. But if you'd like to get started with something familiar, Workbench has a nice SOQL interface.

Pro-tip with Workbench: If you set a browser bookmark after your query runs, you can return to that bookmark and it will re-run your query!

There are many other ways to run SOQL queries including from the Salesforce Developer Console or any number of tools that have been built by 3rd party vendors.

How to Getting Started?

If SOQL is new to you, check out Write SOQL Queries on Trailhead
If you've done some SQL in the past, check out Move from SQL to SOQL on Trailhead
If you'd like to run SOQL from the command line, check out my post on SOQL from the Command Line
Labels:

Comments

Post a Comment

Popular posts from this blog

Salesforce Lighting Migration: Plan for Success

In April 2018, I led the Salesforce Lightning Migration at Postmates. This is how I would do it over again if I could.

Define Goals The goals of a Lightning Migration are: Enable Lightning ExperienceConfigure Lightning ExperienceDocument all Salesforce processesCreate training and support materialsLightning Experience is adopted Easy enough right? Let's go though the plan to see how we accomplish each one. Enable Lightning Experience Just turn it on right? Well, kinda.
Although it may be controversial, I recommend turning it on and hiding the option from all users. This can be done by removing the Lightning Experience User permission from your custom profiles. 
And yes, turn it on in production. 
Why? You're going to turn it on anyway. Salesforce has declared this as the path forward, so you either turn it on now or wait until they flip the switch for you.
Plus, turning this on ahead of time will make deploying from a sandbox much easier. Trust me.
Goal #1 Enable Lightning Exp…
Post a Comment
Read more

SOQL from the Command Line

SOQL and the Command Line go together better than peanut butter and jelly. Here's why.
Once upon a time, I got tired of running Salesforce Reports to get miscellaneous data. I found Workbench and started using their interface to run SOQL queries. This was great for a while, but I knew there was a better way.

Pro-tip with Workbench: If you set a browser bookmark after your query runs, you can return to that bookmark and it will re-run your query!

Enter the SFDX Command Line Interface (CLI). Get ready to take your productivity into hyperdrive! ðŸš€ðŸš€ðŸš€
sfdx force:data:soql:query If there's one command you learn, this is the one. All you have to do is pass a query string into the -q parameter and you're in business. Check it out:
-r | --resultformat This is my 2nd favorite thing. How often do you need to export a csv from Salesforce? And how annoying is it to make throwaway Salesforce reports each time? Yeah, it's the worst.
-r to the rescue! Just add "-r csv" to …
Post a Comment
Read more

Lightning Record Pages for Ultimate Productivity

Salesforce Lightning Experience provides so many configuration options that it's hard to know where to start. I'd like to share how I build Lightning Record Pages to help get you started.

I create Lightning Record Pages with 3 key concepts in mind:
Consistent designSpeedEverything they need is in one place Building a Lightning Record Page that delivers these concepts will enable your users to have ultimate productivity. Let's Take a Look: Account Lightning Record Page Contact Lightning Record Page Opportunity Lightning Record Page Notice Anything? They all look the same. I know, that's on purpose 🤓

Here are a few key similarities:

1. Activity and Chatter are in the same place

It's common to develop a "muscle memory" when doing repetitive tasks like logging calls or posting to Chatter.

⚡ Put components used for repetitive tasks in the same place. ⚡
2. Record Details load first
Salesforce does not recommend this because it hurts page load time. I used to load …
Post a Comment
Read more