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
KunalKunal 

Math Operation Via API

Is there a way to do the following? I want to write a query for the API and testing it first in SForce Explorer which is giving me MALFORMED_QUERY error.
 
 
"SELECT Id,Amount,Payment__c from Opportunity WHERE (Amount-Payment__c)>0 AND Active__c=true"
 
If there is no way to do this then I think , I have to loop through each record checking for the condition. Please let me know ASAP.
 
 
SuperfellSuperfell
You'll have to create a formula field to do the calculation, then filter on that.
KunalKunal

Oh, Yeah.

How come I didn't thought of it before posting. Super quick reply though!