← back to the release
new featureAPI
Compare Values Between Fields in SOQL (Beta)
A new FORMULA() function lets a SOQL WHERE clause do arithmetic and compare values between fields directly, without a formula field or post-processing. Beta, available only in sandbox, Developer Edition, and scratch orgs in API version 68.0 and later; not available in production.
identifiers
SOQLFORMULA()WHERE clause
api versions
68.0
flags
off by defaultno action requiredmin api 68
- how
- Use FORMULA(...) in a SOQL WHERE clause.
- who
- when
- Beta.
- where
- Group, Professional, Enterprise, Performance, Unlimited, Developer, and Database.com editions; beta in nonproduction orgs on API 68.0+.