Access and modify an existing data source sheet filter. To create a new data source sheet filter,
use DataSourceSheet.addFilter(columnName, filterCriteria)
.
Only use this class with data that's connected to a database.
Methods
Method | Return type | Brief description |
---|---|---|
getDataSourceColumn() | DataSourceColumn | Returns the data source column this filter applies to. |
getDataSourceSheet() | DataSourceSheet | Returns the DataSourceSheet that this filter belongs to. |
getFilterCriteria() | FilterCriteria | Returns the filter criteria for this filter. |
remove() | void | Removes this filter from the data source object. |
setFilterCriteria(filterCriteria) | DataSourceSheetFilter | Sets the filter criteria for this filter. |
Detailed documentation
getDataSourceColumn()
Returns the data source column this filter applies to.
Return
DataSourceColumn
— The data source column.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/spreadsheets.currentonly
-
https://www.googleapis.com/auth/spreadsheets
getDataSourceSheet()
Returns the DataSourceSheet
that this filter belongs to.
Return
DataSourceSheet
— The data source sheet, to which this filter belongs.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/spreadsheets.currentonly
-
https://www.googleapis.com/auth/spreadsheets
getFilterCriteria()
Returns the filter criteria for this filter.
Return
FilterCriteria
— The filter criteria for this filter.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/spreadsheets.currentonly
-
https://www.googleapis.com/auth/spreadsheets
remove()
Removes this filter from the data source object.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/spreadsheets.currentonly
-
https://www.googleapis.com/auth/spreadsheets
setFilterCriteria(filterCriteria)
Sets the filter criteria for this filter.
Parameters
Name | Type | Description |
---|---|---|
filterCriteria | FilterCriteria | The filter criteria to set. |
Return
DataSourceSheetFilter
— The filter for chaining.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/spreadsheets.currentonly
-
https://www.googleapis.com/auth/spreadsheets