• firene
  • NEWBIE
  • 0 Points
  • Member since 2013

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies

Hi ,

 

     I have wrote some code to call the Batch Apex,problem with SOQL Query.

 

OwnerReassignment reassign = new OwnerReassignment();

datetime myDate = datetime.newInstance(2013, 5, 1);
string site='Amazon Web Services';
string stus ='open';
reassign.query = 'select lastname,ownerid,country,Territory__c,company from lead where CreatedDate > :myDate AND status=:'+stus+ 'AND Site__c!=:'+site;

reassign.email='XXX@XXX.com';

ID batchprocessid = Database.executeBatch(reassign);

 

Getting System.QueryException: unexpected token: Site__c

 

Help me to Write SOQL,Thanks in advance...