a!queryLogicalExpression() Function
This function cannot be used with Custom Record Field Expressions. It can only be used with Offline Mobile if it is loaded at the top of the form.
For a full list of functions and their feature compatibility, explore the Appian Functions table.


a!queryLogicalExpression( operator, logicalExpressions, filters, ignoreFiltersWithEmptyValues )

Creates a LogicalExpression object that determines the filtration to apply in Query object.

See also: LogicalExpression, Query, QueryFilter


Keyword Type Description



Determines the operation to apply to the set filters. Valid values are "AND" and "OR".


List of LogicalExpression

A list of LogicalExpression objects to apply using the operator parameter, created with a!queryLogicalExpression().


List of QueryFilter

A list of QueryFilters to apply using the operator parameter, created with a!queryFilter().



Specifies whether to ignore filters within a!queryLogicalExpression() if the filter’s value parameter is empty. If you are using nested logical expressions, this parameter must have the same value for each logical expression. For example, if the value is set to true for the parent logical expression, it should be set to true for all children logical expressions. Default: false



Usage considerations

Filtering data

You must specify either the logicalExpression parameter or the filter parameter.

Using the ignoreFiltersWithEmptyValues parameter

By default this parameter will return all data if all of your query filters have empty values. Set this parameter to true if all of your query filters are optional.

For more examples on how to use this parameter with your queries, see Querying on Multiple Conditions and Querying on Nested Conditions.


For more details about how to use queryLogicalExpression(), see Query Recipes.

Open in Github Built: Fri, Jun 24, 2022 (02:11:55 PM)

On This Page