Newer Version Available

This content describes an older version of this product. View Latest

fieldExpression Syntax

fieldExpression uses the following syntax:

1fieldName comparisonOperator value

where:

Syntax Description
fieldName The name of a field in the specified object. Use of single or double quotes around the name will result in an error. You must have at least read-level permissions to the field. It can be any field except a long text area field, encrypted data field, or base64-encoded field. It does not need to be a field in the fieldList.
comparisonOperator Case-insensitive operators that compare values.
value A value used to compare with the value in fieldName. You must supply a value whose data type matches the field type of the specified field. You must supply a native value—other field names or calculations are not permitted. If quotes are required (for example, they are not for dates and numbers), use single quotes. Double quotes result in an error.