Where¶
The criteria to filter the query results.
1 | |
Types¶
QueryBlock¶
Defines a block of criteria to group conditions within a query.
Blocks : Array<QueryBlock>
An array of nested query blocks.
Condition : ( "And" | "Or" )
The condition to combine this block with the next one. If not specified, defaults to "And".
Criteria : Array<QueryCriteria>
An array of criteria to apply within this block.
QueryCriteria¶
Defines a criteria to filter the query results.
Comparison : ( "Equals" | "Different" | "LessThan" | "GreaterThan" | "LessThanOrEqualTo" | "GreaterThanOrEqualTo" | "Like" )
The comparison operator to use. Defaults to "Equals".
Condition : ( "And" | "Or" )
The condition to combine this criteria with the next one. If not specified, defaults to "And".
Expression : string
An expression for the criteria.
IgnoredValues : any
An array of values to ignore.
Value : any
The value or expression to compare against.
ValueType : ( "Direct" | "Expression" )
The type of the