a!queryFilter( field, operator, value, applyWhen )
Creates a value of type QueryFilter for use with a!pickerFieldRecords when defining filter options for expression-backed records, filtering a a!queryRecordType() or a!queryEntity() function call before any grouping or aggregation is computed, or using the a!recordData() function to define additional filters when referencing a set of records from a record type.
See also: a!queryRecordType(), a!recordData(), a!query(), a!recordFilterListOption(), queryfilter
| Keyword | Type | Description |
|---|---|---|
|
|
Any Type |
The name of the field to be filtered. When filtering record data, use the |
|
|
Text |
Filter operator to apply to the data. Valid values: |
|
|
Any Type |
The value to compare to the given field using the given operator. Can be entered as an expression. Optional if the operator value is |
|
|
Boolean |
Determines whether the filter is applied on the query. When set to false, the filter is not evaluated. Default: true. |
QueryFilter
between, the value must be a list of only two elements with the lower bound as the first element and the upper bound as the second.recordType parameter. Use a record type field reference to reference the field you want to filter by. For example, recordType!Employee.fields.department.1
2
3
4
5
=a!queryFilter(
field: recordType!Case.fields.status,
operator: "=",
value: "active"
)
See Query Recipes for examples of filtering data from a data store entity.
