-
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
Salesforce App Development: Custom vs. Pre-Built Solutions
Businesses use Salesforce to streamline operations, manage customer relationships, and improve productivity. However, choosing the right application development approach is essential to achieving these goals.…
5 Reasons why you Shouldn’t Ignore Salesforce Google Ads Integration
Salesforce Google Ads Integration Marketers set aside a sizeable amount of their total marketing budgets to Google Ads. However, there have been huge challenges with…
Retail Business Solutions with Salesforce in 2023
When it comes to a nation’s economic growth, the retail sector is mainly responsible. Consumer spending on retail goods fuels a nation’s ability to generate…
Popular Salesforce Videos
Salesforce Object Search Language: What is SOSL and when to use SOSL?
When to Use SOSL? Use SOSL when you don’t know which object or field the data resides in, and you want to: Retrieve data for…
Introduction to Programming | Live Salesforce Development
Learn Salesforce development from start to finish for free. Want to take your Salesforce Knowledge to the next level? Want to learn advanced Salesforce admin,…
How To Dominate Peak Shopping Seasons with Salesforce Commerce Cloud?
Peak shopping seasons can make or break a business. In our latest webinar, we break down the power of Salesforce Commerce Cloud and how it…
