SOQL query is not working for multiple status check in Apex [closed]

Question

I wrote below query for single status check, it is working but not for multiple status checks, it is throwing errors.

String draft = 'Draft';
String cancel = 'Cancelled';
String cmpnQuery = 'SELECT ID,Name,FROM Campaign where status!=:draft'; //working without issues

 String campQuery = 'SELECT ID,Name FROM Campaign where status NOT IN (draft,cancel)'; // not working

for(Campaign cmpn:Database.Query(cmpnQuery )){
//TO- DO
}

Answer 1

You should make a Set<String> and add the status to it. Like this

Set<String> stringSet = new Set<String>{'draft','cancel'};

Then you can update the query to:

String campQuery = 'SELECT ID,Name FROM Campaign where status NOT IN: stringSet';

Answer 2

Use Quoted String Escape Sequences character

Database.query('SELECT ID,Name FROM Campaign where status NOT IN (\'draft\',\'cancel\')')

Answer 3

Sarvesh and Zach are good anwsers, you can also achieve the same result with the next query.

SELECT Id, Name
FROM Campaign
WHERE Status != 'draft'
AND Status != 'cancel'