Stay organized with collections Save and categorize content based on your preferences.
Detailed documentationgetDataSourceColumn()
Returns the data source column this filter applies to.
ReturnDataSourceColumn — The data source column.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/spreadsheets.currentonlyhttps://www.googleapis.com/auth/spreadsheetsgetDataSourceSheet()
Returns the DataSourceSheet that this filter belongs to.
DataSourceSheet — The data source sheet, to which this filter belongs.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/spreadsheets.currentonlyhttps://www.googleapis.com/auth/spreadsheetsgetFilterCriteria()
Returns the filter criteria for this filter.
ReturnFilterCriteria — The filter criteria for this filter.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/spreadsheets.currentonlyhttps://www.googleapis.com/auth/spreadsheetsremove()
Removes this filter from the data source object.
AuthorizationScripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/spreadsheets.currentonlyhttps://www.googleapis.com/auth/spreadsheetssetFilterCriteria(filterCriteria)
Sets the filter criteria for this filter.
Parameters Name Type DescriptionfilterCriteria FilterCriteria The filter criteria to set. Return
DataSourceSheetFilter — The filter for chaining.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/spreadsheets.currentonlyhttps://www.googleapis.com/auth/spreadsheetsExcept as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-12-02 UTC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-12-02 UTC."],[[["`DataSourceSheetFilter` allows you to access and modify existing filters applied to data source sheets connected to databases."],["You can get information about the filter, such as the column it applies to, the sheet it belongs to, and its criteria."],["It provides methods to remove the filter and to set new filter criteria."],["This class is exclusively for data connected to a database and is not intended for regular spreadsheet data."],["All methods within `DataSourceSheetFilter` require authorization with specific scopes related to spreadsheet access."]]],["`DataSourceSheetFilter` allows interaction with existing filters on database-connected data. Key actions include: retrieving the associated data source column, sheet, and filter criteria using `getDataSourceColumn()`, `getDataSourceSheet()`, and `getFilterCriteria()`, respectively. Filters can be removed with `remove()` or modified using `setFilterCriteria()`. Creating new filters requires `DataSourceSheet.addFilter`. All methods necessitate specific authorization scopes related to spreadsheets.\n"]]
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4