Salesforce has its own version of SQL for running queries across its database that’s referred to as SOQL. Coda needs to use this query language in all of the lookup-type formulas.
This is used for the filter parameter. If you’re looking at Salesforce specific documentation on the web or on the Salesforce website, this is what goes in the WHERE clause. For Coda formulas, this goes in the filter parameter.
The following is a basic structure of a SOQL statement.
NameOperator'Value'
The Name is the unique identifier for a field.
The Label is the readable version My Custom Field, but the Field Name might be My_Custom_Field__c
The Operator is the comparison used to evaluate the value against. <, >, =, etc.
The Value is what you’re trying to find in the data.
The value needs to be wrapped in single quotes ' ' for Salesforce SOQL to know it’s the value part of the clause.
Name 1Operator'Value 1'Logical OperatorName 2Operator'Value 2'
A logical operator that lets you combine multiple expressions. AND, OR, etc.