The toFilter() function formats values into filter-friendly values. Text values will be surrounded by double quotes to allow for exact match filtering. Multi-select pick lists will resolve selected options surrounded by double quotes and separated by commas. Dates will be formatted as “yyyy-MM-dd”. Numbers will resolve to the raw numeric value without any formatting.
Syntax
toFilter(value)
| Argument | Description |
| value
(required) |
The value can be a constant (i.e., hard-coded value, attribute reference, or page-filter reference) and/or references to metrics. The value argument can also be an expression. |
Where Available
Available in all places the expression or injected expression icon is visible, as well as within Filter fields on Cards, Tables and List/View sections.
Examples
| Where | Example(s) |
| Dynamic Filter | {!toFilter(Start_Date__f)} will resolve to “2023-11-01”
|