Calculate Values in a SOQL WHERE Clause (Pilot)

Perform arithmetic calculations directly in your SOQL WHERE clauses using the new FORMULA() function. Compare values between fields without requiring formula fields or post-processing logic, and make your queries more efficient and expressive.

Where: This change applies to Lightning Experience and Salesforce Classic in all editions. Contact your Account Manager or Customer Success Manager to enroll in the pilot.

Note
Note Arithmetic formulas in a SOQL WHERE clause is a pilot service that is subject to the Beta Services Terms at Agreements - Salesforce.com or a written Unified Pilot Agreement if executed by Customer, and applicable terms in the Product Terms Directory. Use of this pilot service is at the Customer's sole discretion.