A QueryItem defines a single filter rule for the evaluation of the result collection of a Query. This filter rule has the following parameters:
| Parameter |
DataType |
Example(s) |
Comment
|
| NAME |
Text |
Any |
The name of the MetaProperty the filter value should be compared for.
|
| OPERATOR |
Text |
=, <=, <, >, >=, != |
The comparison operator. The value must correspond to an item of the QuerySearchItemOperator enumeration.
|
| LIKECOMPARISON |
Boolean |
true / false |
If true, the given item is applied as LIKE filter criteria where a wildcard is automatically added to the end of the filter value; for an additional wildcard at the beginning of the filter value add % - if true, this overrides the OPERATOR configuration.
|
| FILTERVALUE |
Text |
Any |
This filter value is compared to the property values (for the specified MetaProperty) of the objects to find, using the operator. If the comparison result is True, there is a positive match.
|
| INDEX |
Integer |
Any |
Specifies the index of the property value to compare. Use -1 for the standard value.
|
| ISNULL |
Boolean |
true / false |
True, if the query item should match for NULL values; if true, this overrides the LIKECOMPARISON and OPERATOR configuration.
|
| LOGICALAND |
Boolean |
true / false |
If true, the given QueryItem and its predecessor are logically joined using AND; otherwise using OR
|
See also
Query Item