-
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 Commerce Cloud: Delivering Innovation with a Difference
Dip in revenue, inconsistent customer experience, sluggish pace of operations and straight-jacketed scalability aren’t good for business, but when they become routine, the doom isn’t…
Dreamforce 2024: Attendees, Here’s What’s Coming
Dreamforce has always been the crown jewel of tech events, a confluence of innovation, thought leadership, and unparalleled networking opportunities. The excitement surrounding Dreamforce 2024…
What does a Salesforce Professional Do? Exploring Salesforce Roles and Profiles
There are a number of articles and blogs out there discussing the demand, the salaries, or the need for certification for a Salesforce professional. But…
Popular Salesforce Videos
Business Days in Salesforce CRM Analytics (Tableau CRM)
It's common for businesses to want to take business days into account when showing data on a dashboard in CRM Analytics (formerly Tableau CRM) to…
Driving Gamified Interactions on Salesforce Communities With ScoreNotch | Use-Cases
A Salesforce native and lightning-ready product that makes gamification more dynamic and engaging. It encompasses powerful features that boost community engagement and ROI. Do let…
Get Rich Insights on Your Salesforce Users With Tableau | Did You Know
Did you know you can use Tableau to get rich insights on your Salesforce users? Login history, geo, browser, OS, and more are all at…
