-
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
Maximize Your Sales Outcomes With Salesforce High-Velocity Sales
Selling products and services encapsulates what your business is. The effort your Sales reps put into each call defines your firm’s growth and provides you…
5 Essential Tips for Successful Salesforce Migration
In today's digital landscape, businesses rely heavily on robust customer relationship management (CRM) platforms like Salesforce to manage their interactions, data, and sales pipelines. However,…
How Salesforce is Better Than Other CRM?
Salesforce is renowned for its CRM software, which is widely used by businesses and industries. Their CRM has proven to be quite effective throughout different…
Popular Salesforce Videos
How Users Set Up Einstein Activity Capture | Salesforce Tutorial
Say goodbye to busy work. Say hello to smarter selling. When you connect your email and calendar to Salesforce with Einstein Activity Capture, their email…
Top 5 Features Salesforce Winter Release '21
Even though we're in the middle of one of the strangest summers in our lives, we can rely on one constant: releases from Salesforce. It's…
Parent to Child SOQL vs Map | Salesforce Training in Apex
Watch this video to learn all about Parent to Child SOQL vs Map. Do let us know in the comment section if you have any…