FilterOptions API in JavaScript (ES5) Spreadsheet API control

Specifies the options available for filtering data.

Properties

datasource

DataManager

Specifies the data source to be filtered. This can be an external data source managed by a DataManager object.

equalOrPredicates

Predicate[][]

Specifies groups of predicates that are combined using OR logic. This allows filtering based on multiple sets of conditions.

predicates

Predicate[]

Specifies the filter conditions (predicates) for filtering data.