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. SOQL LIKE with Wildcards: In-Between Word Matching Apex The SOQL LIKE operator with wildcards finds text that sits between two specific words in your Salesforce data. This practical guide works through the patterns and the Apex code that builds them. 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 & NOT LIKE: Wildcards, Examples & Best Practices Apex SOQL LIKE and NOT LIKE explained: wildcards (% and _), case sensitivity, escaping, performance gotchas, and the exact Apex bind-variable patterns developers actually use. Formula Field in SOQL WHERE Clause: Best Practices Apex Filtering a SOQL WHERE clause on a formula field works, but the value is calculated per record and can never be indexed. What that costs you, when it is worth it, 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. SOQL CONTAINS vs LIKE vs INCLUDES: When to Use Each Operator Apex SOQL has no CONTAINS keyword. Most queries reaching for one want LIKE with wildcards, or INCLUDES for a multi-select picklist. Pick by field type. 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. SOQL NOT IN, NOT EQUAL & NOT LIKE: Exclusion Patterns Explained Apex Three ways to exclude records in SOQL: NOT IN with subqueries, != / <> for direct comparison, and NOT LIKE for pattern exclusion. When each one wins, and the gotcha with nulls. 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.