SOQL articles
32 articles · Query syntax, operators, filtering and the limits that bound a query.
ApexSalesforce 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....
ApexSalesforce 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...
AdminSalesforce Data Skew: Remediation Strategies
Prevention is the other article. This is for the org you inherited: how to find account, ownership, and lookup skew...
Agentforce & AIBuild Salesforce AI Agent with LangChain, Groq
Build a conversational AI agent that turns plain English into SOQL queries against your Salesforce org, using...
ApexSOQL: 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,...
ApexSOQL CONTAINS vs LIKE vs INCLUDES: Which Operator to Use
SOQL has no CONTAINS keyword. Use LIKE '%text%' on text fields, INCLUDES on multi-select picklists, and SOSL for long...
ApexSOQL NOT IN and NOT EQUAL (!=): Exclusion Syntax and Null Rows
SOQL excludes records three ways: NOT IN for lists and subqueries, != for one value, and (NOT field LIKE) for patterns....
ApexSOQL 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...
ApexFormula 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...
IntegrationPermission 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...
ApexSOQL 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...
ApexSalesforce Spring '26 - Apex Cursors and LWC Expressions
I've been testing the Salesforce Spring '26 preview, and the new Apex Cursors change what is realistic for large data...