-
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
New Salesforce Interface: The Case for Lightning Migration from Classic
As we approach the end of the current year, it’s a great opportunity for businesses to evaluate their existing IT infrastructure and gear up for…
Steps To Connect Marketing Cloud and Salesforce Org
Before installing Marketing Cloud Connect, you need to keep the following Things in your mind - Review the Features page to understand compatibility and product versions. Marketing…
Understanding Roles, Profiles and Permission Sets in Salesforce
Access management is arguably one of the most important components of front-line Salesforce security — but there's a lot more to it than just password…
Popular Salesforce Videos
BradForce Interview with special guest Jason Jung | Landing Your First Salesforce Job
In this video, I have a great conversation with Jason Jung. Jason landed his first Salesforce Job in the middle of a global pandemic. Listen…
Create Customers for Life with the Loyal Program in Salesforce
Ever thought about how you can retain your customers in this cutthroat competition in this growing market? A customer loyalty program is one of the…
Apex Programming Tutorial for beginners : Data Types, Variables and Constants in Salesforce
Apex Programming Tutorial for beginners: Data Types, Variables and Constants in Salesforce.