how to pass picklist value in Dynamic SOQL

Question

I am using dynamic soql where I am reading the conditions from an XML and getting those as a String but I am not able to find it who the query will structure

String query = 'SELECT id, Name FROM CustomObject__c WHERE Status__c =: InProgress';
Database.query(query);

It throws error message as

System.QueryException: Variable does not exist: InProgress

Answer 1

use variable binding

String status = 'InProgress';
String query = 'SELECT id, Name FROM CustomObject__c WHERE Status__c = :status';
List<CustomObject__c> result = Database.query(query);

it is preferable to use variable binding than string concatenation in order to prevent SOQL Injections. Also, if it not necessary to use dynamic SOQL use static SOQL.

String status = 'InProgress';
List<CustomObject__c> result = [
    select id, Name
    from CustomObject__c
    where Status__c =:status
    ];

Answer 2

As Alexander said in his answer, use variable binding or static SOQL.

If you do need to use dynamic SOQL without variables, you will need to add these values as a string(=escaping single quotes):

String query = 'SELECT id, Name FROM CustomObject__c WHERE Status__c = \'InProgress\'';

Note, that I removed : from the query, which is used by Apex to understand that you are using a variable there.

Answer 3

You must add InProgess in quotes('InProgress').

String query = 'SELECT id, Name FROM CustomObject__c WHERE Status__c =: 'InProgress' '; Database.query(query);