Filter
An object that represents a filter formula along with the id of the context row under which the filter function needs to evaluate.
Contents
- formula
-
A formula representing a filter function that returns zero or more matching rows from a table. Valid formulas in this field return a list of rows from a table. The most common ways of writing a formula to return a list of rows are to use the FindRow() or Filter() functions. Any other formula that returns zero or more rows is also acceptable. For example, you can use a formula that points to a cell that contains a filter function.
Type: String
Length Constraints: Minimum length of 0. Maximum length of 8192.
Pattern:
^=.*
Required: Yes
- contextRowId
-
The optional contextRowId attribute can be used to specify the row id of the context row if the filter formula contains unqualified references to table columns and needs a context row to evaluate them successfully.
Type: String
Length Constraints: Fixed length of 77.
Pattern:
row:[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}\/[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}
Required: No
See Also
For more information about using this API in one of the language-specific AWS SDKs, see the following: