a!queryLogicalExpression() Function

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

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

Syntax

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

  • operator (Text): Determines the operation to apply to the set filters. Valid values are "AND" and "OR".
  • logicalExpressions (List of LogicalExpression): (Optional) A list of LogicalExpression objects to apply using the operator parameter, created with a!queryLogicalExpression().
  • filters (List of QueryFilter): (Optional) 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

    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.

Returns

LogicalExpression

Examples

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

See Also

LogicalExpression: Data type that determines the filtration to apply.

Query: The Query data type defines the grouping, aggregation, filtering, paging, and sorting configuration to be applied when querying data.

QueryFilter: The data type used to configure the filter options for a expression-backed record or filter a queryrecord() function call.

FEEDBACK