Getting Error when using map in Dynamic query:- System.QueryException: unexpected token: '(' in the SOQL query

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’ ;

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 ’ ;