Creates a value of type QueryFilter
for use with defining filter options for expression-backed records or filtering a queryrecord()
function call before any grouping or aggregation is computed.
a!queryFilter( field, operator, value )
=
, <>
, >
, >=
, <
, <=
, 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: "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.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.
queryrecord(): Use the queryrecord()
function to execute a user-defined query on a given record type and return the results.