a!queryFilter() Function

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 )

  • field (Text): The dot notation to the field that you want to apply the filter to.
  • operator (Text): The operator to apply to the filter. Valid values include =, <>, >, >=, <, <=, between, in, not in, is null, not null, starts with, not starts with, ends with, not ends with, includes, not includes.
  • value (Text): The value to compare to the given field using the given operator. Can be entered as an expression. Optional if the operator value is is null or not null.




      field: "status",
      operator: "=",
      value: "active"


  • If the operator value is 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.

See Also

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.