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. 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. 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. 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. 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 Export a Salesforce Report to Excel: 4 Methods Compared Admin Formatted Report and Details Only exports produce different files with different row limits, and choosing the wrong one is the usual reason an export comes back short. This guide shows how to export a Salesforce report to Excel, plus list views, opportunities, object data and Reports REST API pulls, and how to check the file before you send it. 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.