-
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
- [adinserter block='9']
-
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
All You Need to Know About Creating Free Salesforce Developer Account
Are you struggling to create a Free Salesforce Developer Account? Do you think you could not find the right resources to guide you step-wise free…
Events in Salesforce Lightning Component
COMPONENT LIGHTNING EVENTS: In Salesforce, the Component Lightning Events are used to interact between the Lightning Components or in other words, we can say that…
What are Apex Triggers? | All You Need to Know
Before reading this blog, you must have basic knowledge of Apex Language and SOQL. Apex triggers can invoke apex code and enable you to perform…
Popular Salesforce Videos
Salesforce Lightning Events Tutorial I Building Component Events (Single Component)
This Salesforce Lightning Events Tutorial will make you learn how to register an event in Salesforce Lightning and handle that event in the source component…
Service Resources and Territories in Salesforce | Salesforce Webinar
Ensure seamless field service operations by setting up Service Resources and Territories in Salesforce Field Service the right way. Organize and manage field service operations…
Salesforce Rest API | Http Methods | Salesforce Integration
This video we will discuss - What is API Different API In Salesforce Rest API in Salesforce HTTP Request HTTP methods Workbench to make HTTP…
