-
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
How to convert BAK file into CSV using ACT EXPORTER TOOL and import in to salesforce
In this Blog, you will learn, how to use the Exporter tool. The Exporter tool allows us to take the client's ACT database BAK files…
Salesforce Ant Migration Tool - The Complete Guide
Ant Migration Tool is one of the three tools available for Salesforce deployment and it is a totally Java based command line for moving metadata…
What Role Does Salesforce Play in High-Tech Success?
The high-tech sector is experiencing explosive growth, emerging as a global economic powerhouse. Projections indicate that this industry's global market value will rise to $16…
Popular Salesforce Videos
5 Reasons To Choose Marketing Automation For Your Business | Salesforce
With the advancement in technology, it has become imperative to move towards more advanced methods to grow your business. Marketing automation is one method that…
Top 10 Features of Salesforce | What is Salesforce | Salesforce Consulting Company
A3logics offers World Class Salesforce Consulting services for your round-off Salesforce cycle from planning, consulting, integration, support, and administration services. We also offer Salesforce app…
Pros & Cons of Lightning Component vs. 3rd party frameworks in Salesforce UI development
Nikita drops by to share his invaluable experience of using popular 3rd party frameworks in Salesforce. http://media.blubrry.com/salesforceway/audio.xmcdn.com/group42/M05/25/57/wKgJ81rXk6XjaZIAAU_I_KtprFM998.m4a