Skip to content

Where

Criteria of query

1
 QueryBlock myQuery.Where

Types

QueryBlock

Blocks : Array<QueryBlock>
Array of criteria blocks

Condition : ( "And" | "Or" )
Condition with next block. If not specified And value is used.

Criteria : Array<QueryCriteria>
Array of criteria

QueryCriteria

Defines a criteria to be used to filter results

Comparison : ( "Equals" | "Different" | "LessThan" | "GreaterThan" | "LessThanOrEqualTo" | "GreaterThanOrEqualTo" | "Like" )
Comparison operator. Default value is Equals.

Condition : ( "And" | "Or" )
Condition with next criteria. If not specified And value is used.

Expression : string
Criteria expression.

IgnoredValues : any
Array of ignored values.

Value : any
Value or Expression to compare

ValueType : ( "Direct" | "Expression" )
Type of value. If not specified Direct value is used.