-
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
Which Industries Can Use Salesforce in 2024?
In today’s digital age, businesses across various sectors are constantly seeking innovative ways to enhance customer relationships, optimize operations, and drive growth. Salesforce, a robust…
Marketing Success Post Pandemic | Salesforce Success Guide
From everything the world has experienced so far, the pandemic has led to two paths—complete paralysis of the business or a springboard towards success. Simply…
What Salesforce's New AgentScript Language Means for Your Agentforce Build
If you've taken an Agentforce build past the demo stage, you've probably hit the same wall every admin and architect hits: the agent works beautifully…
Popular Salesforce Videos
WWE Connector for Salesforce
In this quick video we will show the Workspace Web Edition Connector for Salesforce. The WWE Connector leverage a powerful browser extension to guarantee a…
Access Salesforce Maps Schedule and Manage Saved Events
Watch this video to learn how to Access Salesforce Maps Schedule and Review and Manage Saved Events. Do let us know in the comment section…
Salesforce Lightning Training - Creating Hello World Lightning Component
Data Loader is a utility to perform bulk database operation. Recently Salesforce has changed the way data loaders need to be install. I explain end…
