Skip to main content
New tool CRON Expression Builder — preview next run times before you schedule Apex. Open the builder →

SOQL articles

34 articles · Query syntax, operators, filtering and the limits that bound a query.

3D render of a glowing core representing Salesforce Winter 27 developer features and architecture updatesApex

Salesforce Winter '27 Developer Architecture Guide

Winter '27 raises the Apex heap ceilings to 10 MB and 25 MB and adds native live integration tests in scratch orgs....

· 7 min read 3D icon of interconnected circuits representing Salesforce Winter '27 developer features and tools.Apex

Salesforce Winter '27 Developer Features: Apex, LWC, AI

Winter '27 raises the Apex heap limits, lets integration tests make real HTTP callouts, and opens LWC templates to...

· 5 min read 3D Salesforce logo illustrating data skew with glowing error blocksAdmin

Salesforce Data Skew: Remediation Strategies

Prevention is the other article. This is for the org you inherited: how to find account, ownership, and lookup skew...

· 6 min read A 3D magnifying glass inspecting text, illustrating the concept of SOQL LIKE wildcards for precise data searching.Apex

SOQL LIKE with Wildcards: In-Between Word Matching

The SOQL LIKE operator with wildcards finds text that sits between two specific words in your Salesforce data. This...

· 6 min read 3D model of a neural network linking to a Salesforce cloud icon, representing a Salesforce AI agent.Agentforce & AI

Build Salesforce AI Agent with LangChain, Groq

Build a conversational AI agent that turns plain English into SOQL queries against your Salesforce org, using...

· 7 min read SOQL: The Complete Guide to Salesforce Object Query LanguageApex

SOQL: The Complete Guide to Salesforce Object Query Language

SOQL is the SQL-flavored query language Salesforce ships for reading data. This pillar page covers every operator,...

· 6 min read SOQL CONTAINS vs LIKE vs INCLUDES: When to Use Each OperatorApex

SOQL CONTAINS vs LIKE vs INCLUDES: When to Use Each Operator

SOQL has no CONTAINS keyword. Most queries reaching for one want LIKE with wildcards, or INCLUDES for a multi-select...

· 4 min read SOQL NOT IN, NOT EQUAL & NOT LIKE: Exclusion Patterns ExplainedApex

SOQL NOT IN, NOT EQUAL & NOT LIKE: Exclusion Patterns Explained

Three ways to exclude records in SOQL: NOT IN with subqueries, != / <> for direct comparison, and NOT LIKE for pattern...

· 5 min read SOQL ORDER BY: Sort, NULLS FIRST/LAST & Multi-Column ExamplesApex

SOQL ORDER BY: Sort, NULLS FIRST/LAST & Multi-Column Examples

Every SOQL ORDER BY pattern in one place, from ASC/DESC and multi-column priority to NULLS FIRST vs NULLS LAST, sorting...

· 5 min read 3D magnifying glass inspecting a glowing formula on a circuit board, illustrating formula fields in SOQL WHERE clauses.Apex

Formula Field in SOQL WHERE Clause: Best Practices

Filtering a SOQL WHERE clause on a formula field works, but the value is calculated per record and can never be...

· 8 min read A 3D digital padlock representing secure permission set assignment data extraction from Salesforce systems.Integration

Permission Set Assignment: Exporting Data Outside Salesforce

How to query PermissionSetAssignment records in SOQL and move them to an external system with the REST API or Bulk API...

· 3 min read Debugging stale SOQL return values after a successful Salesforce UI field update.Apex

SOQL Returns Old Value After UI Update

A Salesforce UI edit looks committed, and then an Apex SOQL query reads the old value back. The mismatch between the UI...

· 5 min read