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.
a!queryFilter( field, operator, value )
recordType!
domain. For example, recordType!Case.fields.caseName
. When filtering data from a data store entity, use the field name in quotations. For example, "department"
.=
, <>
, >
, >=
, <
, <=
, between
, in
, not in
, is null
, not null
, starts with
, not starts with
, ends with
, not ends with
, includes
, not includes
.is null
or not null
.QueryFilter
1
2
3
4
5
=a!queryFilter(
field: recordType!Case.fields.status,
operator: "=",
value: "active"
)
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!Employee.fields.department
.a!recordFilterListOption(): use the a!queryfilter()
function to create a value for the filter
parameter of this function.
query: the query data type defines the grouping, aggregation, filtering, paging, and sorting configuration to be applied when querying data.
queryfilter: this is the data type the a!queryfilter()
function returns.
a!queryRecordType(): Use the a!queryRecordType()
function to execute a user-defined query on a given record type and return the results.
a!queryEntity(): Use the a!queryEntity()
function to execute a user-defined query on a given data store entity and return the results.
a!recordData(): Use the a!recordData()
function to reference a set of records from a record type and allow additional filtering if necessary.