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. Convert SOQL to Excel dates - Fix Salesforce ISO strings General Exporting Salesforce data only to find Excel can't read the dates is a huge pain. Here is a quick formula to clean up those ISO strings so you can get back to your analysis. 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. Build Salesforce AI Agent with LangChain, Groq Agentforce & AI Build a conversational AI agent that translates natural language into SOQL queries for your Salesforce org. This guide leverages LangChain, Groq, and the langchain-salesforce integration to streamline data access. 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. Salesforce Flow Best Practices: 12 Rules That Prevent 90% of Errors Flow Salesforce Flow best practices most teams skip — bulkification, trigger choice, fault paths, and subflow design — distilled into the 12 rules I apply on every implementation. 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. What are Salesforce Big Objects? A Practical Guide Admin If you are trying to store millions of logs in a custom object, you are headed for trouble. I will show you how Salesforce Big Objects handle massive datasets without tanking your org performance. Salesforce Code Quality: Automated PR Comments DevOps Enforce Salesforce code quality by automating static analysis and injecting findings as comments directly into pull requests. This empowers developers with immediate, actionable feedback, improving code maintainability and reducing technical debt. 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. 20 Salesforce Interview Questions and Answers for 2025 Interview Prep Prepping for a Salesforce role is about more than just memorizing documentation. I have put together the questions I actually see in interviews, covering everything from Flow logic to LWC. These answers focus on real-world scenarios so you can show hiring managers you know your stuff.