a!queryLogicalExpression() Function

Function

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

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

See also: LogicalExpression, Query, QueryFilter

Parameters

Keyword Type Description

operator

Text

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

logicalExpressions

List of LogicalExpression

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

filters

List of QueryFilter

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

ignoreFiltersWithEmptyValues

Boolean

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

Returns

LogicalExpression

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.

Examples

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

Open in Github Built: Thu, Sep 16, 2021 (04:12:04 PM)

On This Page

FEEDBACK