-
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
Data Quality Control Using Validation Rules | Salesforce Guide
With such countless changes in Salesforce records made by workers consistently, it could be difficult to monitor the nature of the information. With the assistance…
Salesforce Custom Objects and Behavior - All You Need to Know
At the point when you make or empower highlights for a custom article, Salesforce makes elements to help your custom item. For instance, when you…
What Is Imported for Business Accounts and Contacts?
REQUIRED EDITIONS Accessible in: Salesforce Classic (not accessible in all organizations) and Lightning Experience Accessible in: All Editions, with the exception of Database.com Organization import…
Popular Salesforce Videos
How to Test Your Process Builder | Salesforce
In this video, Appopedia provides helpful tips on how to test your process builder in Salesforce. She explains how to create a test user, what…
5 Important Topics to Crack Salesforce Platform Developer 1 Exam
In this video, Shrey gives you an important topic which gonna be really very helpful for crack the Platform Developer 1 Certification. Without mastering these…
Salesforce Winter Release '22 Highlights
Watch this webinar video to learn about new and improved features and how you can take full advantage of the latest enhancements. Let us know…
