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. Convert SOQL to Excel dates - Fix Salesforce ISO strings Admin Export Salesforce data, then find Excel can't read the dates. 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 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. Integrating Cursor AI with SFDX for Development DevOps What it actually takes to run the Cursor editor inside a Salesforce DX workflow. Worth weighing up how it handles boilerplate generation, debugging and SOQL construction in a standard SFDX project structure before you switch. Permission Set Assignment: Exporting Data Outside Salesforce Integration How to query PermissionSetAssignment records in SOQL and move them to an external system with the REST API or Bulk API 2.0, without turning the export into a security problem. Build Salesforce AI Agent with LangChain, Groq Agentforce & AI Build a conversational AI agent that turns plain English into SOQL queries against your Salesforce org, using LangChain, Groq, and the langchain-salesforce integration. 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. Salesforce Flow Best Practices: 12 Rules That Prevent 90% of Errors Flow The 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. Using the TwoFactorMethodsInfo object for Salesforce MFA Admin If you need to audit MFA compliance in your org, TwoFactorMethodsInfo is the object to know. It shows you exactly which verification methods your users have registered, without opening every user record by hand. 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. 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. Here is how Salesforce Big Objects handle massive datasets without tanking your org performance. How to View Converted Leads in Salesforce - Guide Admin Ever wonder where your leads go after you hit convert? They aren't gone, just hidden from your standard views. Here is how to find them with a report, global search, or a quick query.