-
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
Salesforce Tips and Tricks for Data Integration
User experience is one of the most important aspects of any prominent business endeavor. However, to keep your consumers satisfied with your service or product…
Salesforce Sales Cloud Basics - An Overview
In this top salesforce blog, we will be discussing, the basics of Salesforce Sales Cloud and What is the Purpose of Sales Cloud in Salesforce.…
5 Benefits of Deploying Salesforce CRM in the Manufacturing Industry?
Every industry focuses on customer satisfaction. Be it B2B (business to business) or B2C (Business to Customer), customer satisfaction is the primary concern. Amazing service…
Popular Salesforce Videos
Send Salesforce Field Service Mobile App Device Logs For iOS
This video will demonstrate how to send device logs from the Field Service App for iOS / Android. Salesforce Support may ask you to send…
How to Configure Lightning Sales Path Salesforce
In this video, Pratima provides a detailed demo on how to configure the Lightning Sales Path, the Lead path for Standard and custom objects, the…
6 Best Salesforce Development Training Courses | Learn Salesforce Development Easily
In this video, I'm talking about the 6 Best Salesforce Development Training Courses that are available over Udemy for the novice or Intermediate Salesforce Developer.…
