-
Can we use Map in dynamic query?
Hello, Can we use Map in dynamic query?
-
2 Replies
-
Yes, you can please refer here :- http://salesforce.stackexchange.com/questions/117746/why-i-can-not-use-map-in-dynamic-query/117951#117951
-
Hi Piyush,
You cannot directly use mapname.keyset() or mapname.values() in dynamic queries as dynamic query doesnt allow to map methods to be used in it.
For this you need to fill all the keys or values in a set or list and then IN check to query filterd data
For ex.
set<string> mapkeys=new set<string>()mapkeys.addAll(mapname.keyset());
string query='Select id from lead where fieldName IN:mapkeys'
Log In to reply.
Popular Salesforce Blogs
Build a Salesforce Lead Machine Easily
“There is a difference between — waiting for something good to happen and going all out to make it happen”. One of the biggest aspects…
What is Pardot in Salesforce and Does Your Business Need it in 2024?
Many businesses consider marketing automation to be a must-have. According to the latest Salesforce State of Marketing Report, the average enterprise has 900 (!) different applications…
Platform Events in Salesforce | The Ultimate Guide
Platform events are an essential part of the Salesforce platform. These events are custom-defined objects that enable real-time data sharing among different Salesforce components and…
Popular Salesforce Videos
The Story of Salesforce. How Marc Benioff Built The Best CRM
This video, How It Happened explains the story of how Salesforce went from a small startup in San Francisco to become the leading CRM provider.…
COVID 19 Tracker in Salesforce Lightning Aura Component
In this video, we are developing a lightning Component to track the current pandemic COVID19 Stats Tracker which shows the current situation of all countries…
Apex Scheduler in Salesforce | Asynchronous Apex
Asynchronous Apex 1. Apex Scheduler 2. Interfaces in Apex Scheduler 3. Making callout using Apex Scheduler 4. Points to Remember Upcoming Video on How to…
