Search
Results for “SOQL LIKE”
20 results
SOQL vs SOSL - Which Salesforce Query Should You Use? Apex Choosing between SOQL vs SOSL can be tricky when you are first starting out. I break down exactly when to use each one so you can keep your code fast and avoid hitting those annoying 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 deep dives on LIKE, NOT IN, ORDER BY, joins, aggregates, and SOSL alternatives. SOQL LIKE with Wildcards: In-Between Word Matching Apex Learn how to leverage the SOQL LIKE operator with wildcards to perform powerful searches for text that exists between specific words in your Salesforce data. This practical guide provides Apex code examples to enhance your query capabilities. Dynamic SOQL in Loops: Security Review Impact for Managed Packages Apex We definitively answer whether dynamic SOQL executed within loops fails Salesforce Security Review for managed packages, confirming it's not a security violation. Learn the recommended architectural patterns for handling dynamic, object-aware queries without failing the scan. Formula Field in SOQL WHERE Clause: Best Practices Apex Leverage the power of formula fields directly within your SOQL WHERE clauses to build more dynamic and insightful queries. This guide explores the nuances and provides actionable advice for Salesforce developers. SOQL Returns Old Value After UI Update Apex When a Salesforce UI modification appears committed but subsequent Apex SOQL queries retrieve stale data, it often points to transaction context or caching issues. This discrepancy between the UI state and the database record retrieved via Apex needs systematic debugging. 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. 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 deep-dive guides on every sub-topic. SOQL CONTAINS vs LIKE vs INCLUDES: When to Use Each Operator Apex SOQL doesn't have a CONTAINS keyword — but most queries searching for one need LIKE with wildcards or INCLUDES for multi-select picklists. Here's the decision rule. 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 The Salesforce Winter '27 release introduces significant enhancements for developers, including increased Apex heap limits and advanced LWC capabilities. Discover how these updates can streamline your development workflow. Apex Best Practices - Salesforce Developer Interview Guide Apex Ever hit a SOQL 101 error on a Friday afternoon? This guide covers the Apex best practices you need to build scalable code and ace your next Salesforce interview. Apex Trigger Cheat Sheet - Master Salesforce Triggers Apex Tired of hitting SOQL limits and dealing with messy triggers? I put together this Apex Trigger Cheat Sheet to help you keep your code clean and your deployments smooth. 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.