Dynamic SOQL query giving error

Question

I am trying to execute below query and getting error which says Unexpected token IN Can someone please help to understand what is wrong here.

String str = 'SELECT Name FROM Account';
String str1='WHERE';
String str3='Name IN (\'test\',\'test9\')';
list<Account> accclist=Database.query(str+str1+str3);
system.debug(accclist);

However when I run this below one it runs perfectly fine.

list<Account> accclist=Database.query('SELECT Name FROM Account WHERE Name IN (\'test\',\'test9\')');

Answer 1

There are multiple issues in your code.

1.Add spaces before WHERE & Name clauses.

2.Since you are using single quotes in condition , you will need to escape it as below :

str3='Name IN (\'test\',\'test9\')';

More info - https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_quotedstringescapes.htm

3.Also , Database.query returns List of sObjects which needs type casting.

Final code will look as below:

String str = 'SELECT Name FROM Account'; 
String str1=' WHERE'; 
String str3=' Name IN (\'test\',\'test9\')'; 
List<Account> accclist=(List<Account>)Database.query(str+str1+str3); 
system.debug(accclist);

Please refer the guide for more info.