Apex Code Development You need to sign in to do that
Don't have an account?
Naresh Chanda System.QueryException: expecting a colon, found <column name>
When trying to execute a batch with the query -
'Select id,name,billingstreet,billingcity,billingpostalcode,BillingState,BillingCountry,EQProcessedTime__c,'+
'HasEQProcessed__c, Fax, Phone, CurrencyIsoCode from ' +objToMigrate+' WHERE createddate > EQProcessedTime__c OR LastModifiedDate > EQProcessedTime__c order by createddate asc limit '+numRecsToMigrate;
I get the below error -
FATAL_ERROR|System.QueryException: expecting a colon, found 'EQProcessedTime__c'. EQProcessedTime__c is a custom column on Account that contains the timestamp the account is processed. Can anyone please advise on how to solve this?
'Select id,name,billingstreet,billingcity,billingpostalcode,BillingState,BillingCountry,EQProcessedTime__c,'+
'HasEQProcessed__c, Fax, Phone, CurrencyIsoCode from ' +objToMigrate+' WHERE createddate > EQProcessedTime__c OR LastModifiedDate > EQProcessedTime__c order by createddate asc limit '+numRecsToMigrate;
I get the below error -
FATAL_ERROR|System.QueryException: expecting a colon, found 'EQProcessedTime__c'. EQProcessedTime__c is a custom column on Account that contains the timestamp the account is processed. Can anyone please advise on how to solve this?