toFilter()

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 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”
>{!toFilter(Percent__c*100)} will resolve to ” > 50%” >50{!toFilter(Lead_Partner__f)} will resolve to “ABC Advisors”, “Consultants R Us”, “Five Star Partners”{!toFilter(ARR__c)} will resolve to 150000

 

Updated on January 29, 2024

Related Articles