Search
Results for “SOQL LIKE”
20 results
SOQL vs SOSL - Which Salesforce Query Should You Use? Apex Picking between SOQL vs SOSL trips up a lot of people early on. Here is how I decide which one to reach for, so your code stays fast and you stop hitting governor limits. SOQL: The Complete Guide to Salesforce Object Query Language Apex SOQL is the SQL-flavored query language Salesforce ships for reading data. This pillar page covers every operator, every clause, and links to detailed pages on LIKE, NOT IN, ORDER BY, joins, aggregates, and SOSL alternatives. Dynamic SOQL in Loops: Security Review Impact for Managed Packages Apex Dynamic SOQL inside a loop does not fail Salesforce Security Review for a managed package, because the scan treats it as a governor limit problem rather than a security violation. Here are the query patterns to reach for when the object and fields are only known at runtime. SOQL LIKE and NOT LIKE: Wildcards, Syntax and Apex Examples Apex SOQL has no NOT LIKE operator. Write (NOT Name LIKE '%x%') instead. This guide covers % and _ wildcards, escaping, binding Apex variables and lists, and which field types LIKE accepts. SOQL CONTAINS vs LIKE vs INCLUDES: Which Operator to Use Apex SOQL has no CONTAINS keyword. Use LIKE '%text%' on text fields, INCLUDES on multi-select picklists, and SOSL for long text or several objects. The field type decides, and the wrong pick is a hard error. SOQL NOT IN and NOT EQUAL (!=): Exclusion Syntax and Null Rows Apex SOQL excludes records three ways: NOT IN for lists and subqueries, != for one value, and (NOT field LIKE) for patterns. Unlike SQL, all three keep rows where the field is null. SOQL Formula: Formula Fields and FORMULA() in WHERE Apex SOQL gives you two ways to filter on a calculated value: a formula field in WHERE, or the Winter '27 FORMULA() beta for comparing two fields. Here is what each one costs, when a formula field can get an index, and when to filter in Apex instead. Apex: The Complete Guide to Salesforce's Programming Language Apex Apex is Salesforce's strongly-typed, server-side language. This pillar covers data types, triggers, async patterns, governor limits, testing, and the detailed guides on every sub-topic. Apex String Class: 30 Methods Salesforce Developers Use Daily Apex Every Apex String method that matters in real code: split, join, contains, trim, escape, format, and the ones that break unexpectedly with null. Plus the SOQL-injection escape pattern. Salesforce Winter '27 Developer Features: Apex, LWC, AI Apex Winter '27 raises the Apex heap limits, lets integration tests make real HTTP callouts, and opens LWC templates to complex expressions. What each change means for the code you write. Apex Trigger Cheat Sheet - Master Salesforce Triggers Apex Tired of hitting SOQL limits and untangling messy triggers? This Apex Trigger Cheat Sheet covers the context variables, the before and after phases, bulkification, and the handler pattern.