Difference between revisions of "QUERYITEM"

Revision as of 10:40, 24 March 2015

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	Name of MetaProperty the filter values should be searched in
OPERATOR	Text	=,<,>,>=,...	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 filtervalue; for an additional wildcard at the beginning of the filter value add *
FILTERVALUE	Text	Any	the value the objects are compared to
INDEX	Integer	Any	property has index values and filtering should consider a certain index
ISNULL	Boolean	true / false	searched for NULL values
LOGICALAND	Boolean	true / false	if true, the given QueryItem and its predecessor are logically joined using AND; otherwise using OR

@@ Line 19: / Line 19: @@
 | NAME || {{Text}} || Any || Name of MetaProperty the filter values should be searched in
 |-
-| OPERATOR || {{Text}} || =,<,>,>=,<= || value must correspond to an item of the QuerySearchItemOperator enumeration
+| OPERATOR || {{Text}} || =,<,>,>=,... || 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 filtervalue; for an additional wildcard at the beginning of the filter value add '''*'''