FilterComparisonType

FilterComparisonType enumeration

The type of comparison made between FieldName and Value that acts as selection criteria for the filter.

Members

Member nameDescription
EQUALSThe value of Field equals Value.
DOES_NOT_EQUALThe value of Field does not equal Value.
IS_GREATER_THANThe value of Field is greater than Value.
IS_GREATER_THAN_OR_EQUAL_TOThe value of Field is greater than or equal to Value.
IS_LESS_THANThe value of Field is less than Value.
IS_LESS_THAN_OR_EQUAL_TOThe value of Field is less than or equal to Value.
IS_WITHINThe value of Field is within Value.
IS_NOT_WITHINThe value of Field is not within Value.
CONTAINSThe value of Field contains Value.
DOES_NOT_CONTAINThe value of Field does not contain Value.
CONTAINS_EXACTLYThe value of Field exactly contains Value.
IS_ONE_OFThe value of Field equals to one of the specified Values. Used in AutoFilters.
UNDEFINEDUndefined value.

See Also