-
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
Bric Web App - Accessing your card directory online
Bric Web App - Accessing your card directory online It's great to have business cards saved on mobile Apps like Bric App, accessed on the go…
Inserting Records in Account or (any other sObject) Through Postman in Salesforce
We are using postman from API testing and request management to hit API by get or post and received data in the form of JSON…
Automation studio in Marketing cloud
Automation Studio - Automation Studio makes Marketing Cloud email sends, queries, imports, and more happen automatically. Automation Studio is a Salesforce Marketing Cloud application used…
Popular Salesforce Videos
Google Lead Form Extension To Salesforce | Salesforce Tutorial
Google Lead Form extension to Salesforce. This tutorial will cover the following points - 1. Introduction Learn how to integrate leads from Google lead form…
Apex Scheduler Part II | Asynchronous Apex | Salesforce Video Tutorial
Asynchronous Apex 1. Apex Scheduler 2. Ways to run apex scheduler 3. Cron Expression 4. Examples Upcoming Video on Batch Apex Hope you guys enjoy…
Customize Salesforce in a Flash with Lightning
This video shows you how to use Lightning App Builder to make page customizations without any code. This enables admins to tailor Lightning Experience for…
