function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

SOQL Query Assistance, multiple Where

I am obviously missing something obvious, but this query just doesn't work, and i can't work out why, can somebody assist?


SELECT Id,Name,Amount,R2_Job_Ref__c,R2_Shipping_Post_Code__c,Shipping_Postcode_2__c
FROM Opportunity
WHERE Shipping_Postcode_2__c != R2_Shipping_Post_Code__c AND R2_Shipping_Post_Code__c != null





Rakesh BoddepalliRakesh Boddepalli

In your where clause you cannot compare to a field value in the object.


So in your case Shipping_Postcode_2__c != R2_Shipping_Post_Code__c wont work .

First retrieve the results and use if condition to filter out the results.



Yes, Rakesh is right. You can't run queries like you would in normal SQL.

Ah i see, that's rather annyoing and inefficient.


But thanks for the reply, will stop banging my head aginst it and add another if loop :)