-
Is there any way in query to do Like against a List of Values?
Hi All,
Is there any way in query to do Like against a List of Values?
SELECT Id FROM Account WHERE Name LIKE IN:listName
where listName is a list of string. I can make a dynamic query by doing OR with all the elements, but I was looking for a more elegant way to do this.
Thanks
-
1 Reply
-
Hi Pranav,
You can do this by query like :-
String[] searchitem = {'%searchtext1%','%searchtext2%'};
List<Accounts> acc = [select id, name from Account where name like :searchitem];
Log In to reply.
Popular Salesforce Blogs
Lightning Web Components — Build Lightning Fast Salesforce Apps
Salesforce launched Lightning Web Components as part of Spring ’19 pre-release to enable a quicker and easier way to program applications on the Salesforce Lightning platform. It…
Why and How’s of Salesforce Training
Imagine you buying a CRM for your sales team after taking time to evaluate, test, and negotiate with the vendor and not use it eventually.…
From Keyword-Based Knowledge Bases to AI-First Portals: Why Customer Support Needs to Evolve
Customer expectations are at an all-time high. Whether they are students trying to access enrollment details, patients asking about billing, or policyholders checking their claim…
Popular Salesforce Videos
Non-technical But Want to Build Career in Salesforce?
In this video Shrey gave the answer to the following questions: 1. What is the next step after doing Certification in Salesforce Administrator? 2. How…
Salesforce CPQ Implementation Best Practices
Follow these Salesforce CPQ implementation best practices across various phases for optimal results: Preparation phase, Implementation phase, Customization, User adoption, and Post Implementation phase. Each…
How to Connect Salesforce Billing Payment Gateways (COMPILATION)
In this compilation, we’ll show you what you need to know about using your preferred payment gateway with Salesforce Billing + CPQ - like how…
