-
Getting Error when using map in Dynamic query:- System.QueryException: unexpected token: '(' in the SOQL query
Map<Id, Contact> mapOfIdVsContact = new Map<Id, Contact>();
for(Contact con : [Select Id from Contact])
{
mapOfIdVsContact.put(con.Id, con);
}String s = 'Select Id from Contact Where Id IN : maps.keySet()' ;
List<Contact> cont = Database.query(s);
System.debug('@@' + cont);Error:- Line: 37, Column: 1 System.QueryException: unexpected token: '('
-
3 Replies
-
Hi Nitish
You can't use Map.keySet() directly in the dynamic, for this you must add map.keySet() either in a set or in list after that you can use it in your Dynamic query.
In your case what you can do is:
make a set of ids
set<id> setofids=new set<id>();
setofids= maps.keySet();
now use this set in your dynamic soql like this
String s = ‘Select Id from Contact Where Id IN :setofids’ ;
- [adinserter block='9']
-
Also I have notices a difference of name between the variable you specified and the one referred in code. That too could be troublesome.
-
Hi,
You must add map.keySet() either in a set or in list after that you can use it in your Dynamic query.
set<id> idSet=new set<id>();
idSet = maps.keySet();
String s = ‘Select Id, name from Contact where Id IN :idSet ’ ;
Log In to reply.
Popular Salesforce Blogs
6 Problems that Salesforce can Solve for your Business in 2024
In today’s fast-paced business world, staying ahead means tackling challenges head-on. Salesforce, a powerful CRM platform, has transformed how companies operate, earning the trust of…
Salesforce Process Automation Best Practices
Salesforce Process Builder was by far one of Salesforce Users' most helpful and popular features. Salesforce uses Process Builder to automate business operations. Relatively new…
Salesforce Winter '23 Marketing Updates
Let's take a look at the marketing updates that have been introduced in the Salesforce Winter '23 release. Marketing Cloud Account Engagement (Pardot) Automate Tasks…
Popular Salesforce Videos
Integrating Salesforce Data Cloud With Other Clouds
In this extract, our speakers discussed the integration capabilities of the Salesforce Data Cloud with other clouds. Salesforce data cloud integrates with a wide range…
eShopSync for QuickBooks - A Salesforce QuickBooks Connector
One of the best Quickbooks Integration Solution With Salesforce. It efficiently sends QuickBooks data (Categories, Users, Products, and Orders) to Salesforce. For more information, please…
Heroku | Salesforce Development Course
Knowledge of Heroku is also required to crack the Salesforce PD 1 Certification Examination. Let’s understand what Heroku is and what are its uses, in…
