-
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
Preparation for Unplanned Downtime in Salesforce
Get Ready for Impromptu Downtime As a framework blackout is more a matter of when as opposed to in the event that, IT and business…
Guide To Writing Batchable Classes In Salesforce
Ever heard of “Batch classes” in Salesforce and felt a bit puzzled? Don’t worry; it’s simpler than you think! Imagine you’re baking cookies. You don’t…
Protect your Data in Salesforce | All You Need to Know
Salesforce is a powerful cloud-based customer relationship management (CRM) system that helps you manage your customers, leads, accounts, and more. It can also be a…
Popular Salesforce Videos
Salesforce Winter '22 Product Release Highlights!
Watch this video to learn about the Salesforce Winter '22 Product Release Highlights. 0:00 - Winter Release Preview 0:10 - Pipeline Inspection Enhancements 0:23 -…
Join My Salesforce Team at Google!
We are hiring four Salesforce Technical Architects on my team at Google. I believe these roles are on one of these most interesting Salesforce implementations…
How To Become A Salesforce Administrator | Salesforce Administrator Training
This "How to become a Salesforce Administrator" video will help you understand who is a Salesforce Administrator and what are their roles and responsibilities. It…
