-
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
Create a search bar key to search Account name using lightning component.
Introduction: A Lightning Component is an UserInterface framework which is used for the development of dynamic web applications which can be used in mobile Phone…
Education Cloud, Salesforce’s Powerful Proposal for the Education Industry
Today, the world develops around information and communication technologies (ICT). These have transformed the way most sectors of society are managed. In this context, educational…
Salesforce AppExchange: A Complete Guide
Introduction Talking about Salesforce, it is a cloud-based software company that has headquarters in San Francisco, California. It provides an array of services for CRM…
Popular Salesforce Videos
Traditional AI vs Generative AI | What the difference? | Salesforce
Explore how traditional AI differ from Generative AI from this extract from our latest webinar! We're going to explore the strengths and not-so-strong points of…
How to use Cauzali in Salesforce Service/sales cloud and all of Salesforce industry clouds. Add functionality to your users with Cauzali
With a maximum price of $6.000 a year for your org. You and your colleague can make all the solutions you want including Community solutions.…
Salesforce User Experience UX Designer Certification
The Salesforce User Experience (UX) c is designed for individuals who have at least 6 months in UX design and 3–6 months’ experience utilizing UX…
