Creates a value of type
QueryFilter for use with defining filter options for service-backed records or filtering a
queryrecord() function call before any grouping or aggregation is computed.
a!queryFilter( field, operator, value )
not starts with,
not ends with,
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!facetOption(): 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.