[SalesForce] Dynamic soql : Unexpected token ‘{‘

Set<Id> sId = new Set<Id>{};
sId.add('a0df000000063A9AAI');
sId.add('a0df00000006P2cAAE');
String squery = 'SELECT Id, Name FROM Engagement__c  WHERE Id IN:'+sId;
List<Engagement__c> lst = database.query(squery);   
System.debug('----list size:'+lst.size());

Im getting the following error

System.QueryException: unexpected token: '{'

Please helppppp! thanks

Best Answer

Syntax is wrong.

Either use this way :-

Set<Id> sId = new Set<Id>();

Set<Id> sId = new Set<Id>{'a0df000000063A9AAI','a0df00000006P2cAAE'};

// no need to use '+sid;
String squery = 'SELECT Id, Name FROM Engagement__c  WHERE Id IN:sId';

// else is correct
List<Engagement__c> lst = database.query(squery);   
System.debug('----list size:'+lst.size());

Why it cannot be +sId?

Using this approach will lead to wrong SOQL syntax. For ex:

Query String will become:

SELECT Id, Name FROM Engagement__c  WHERE Id IN:{a0df000000063A9AAI,a0df00000006P2cAAE}

which is a wrong syntax for SOQL query.

Related Solutions

[SalesForce] What’s wrong with this SOQL

Any time you use a literal String in a query, the value must be wrapped in single quotes. So in addition to removing the double AND, you need to wrap your value in quotes. If you debug the query, you will probably see

SELECT Id, BillingPostalCode, County_Name__c
FROM Account
WHERE ZipCodeLen__c = 9
AND AND BillingCountry = United States

Instead you should wrap it in quotes and escape it.

String accountQuery = 'SELECT Id, BillingPostalCode, County_Name__c '+
    'FROM Account WHERE ZipCodeLen__c = 9 AND BillingCountry = \''
    + String.escapeSingleQuotes(Country) + '\'';

Which should yield:

SELECT Id, BillingPostalCode, County_Name__c
FROM Account
WHERE ZipCodeLen__c = 9
AND BillingCountry = 'United States'

Try running them both in the query editor in the dev console.

[SalesForce] Dynamic SOQL :System.QueryException: unexpected token: <

Your query in for loop is correct

Use soql same in system debug as well

System.debug('Query : ' + 'Select Id from ' + objName + ' where CreatedDate <=: reqDate');

Here I can see you are using soql inside for loop. I guess the above list objAPINames . it will contain only few sobject so it should not hit the soql governer limits

Updates

Another issue in for loop soql, before where you need to give space

for(sObject s : Database.Query('Select Id from ' + objName + ' where CreatedDate <=: reqDate'))

Best Answer

Related Solutions

[SalesForce] What’s wrong with this SOQL

[SalesForce] Dynamic SOQL :System.QueryException: unexpected token: <

Updates

Related Topic