Changes

QUERYITEM

372 bytes added, 16:59, 3 December 2019
! style="width:150px" | Parameter !! DataType !! Example(s) !! Comment
|-
| NAME || {{Text}} || Any || Name The name of the MetaProperty the filter values value should be searched incompared for.
|-
| OPERATOR || {{Text}} || =, <=,<,>,>=,... != || The comparison operator. The value must correspond to an item of the QuerySearchItemOperator enumeration.
|-
| LIKECOMPARISON|| {{Boolean}} || true / false || if If true, the given item is applied as '''LIKE''' filter criteria where a wildcard is automatically added to the end of the filtervaluefilter value; for an additional wildcard at the beginning of the filter value add '''%'''- if true, this overrides the OPERATOR configuration.
|-
| FILTERVALUE|| {{Text}} || Any || the This filter value is compared to the property values (for the specified MetaProperty) of the objects are compared 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 has index values and filtering should consider a certain indexvalue to compare. Use '''-1''' for the standard value.
|-
| ISNULL|| {{Boolean}} || true / false|| searched True, if the query item should match for NULL values; if true, this overrides the LIKECOMPARISON and OPERATOR configuration.
|-
| LOGICALAND || {{Boolean}} || true / false || if If true, the given QueryItem and its predecessor are logically joined using '''AND'''; otherwise using '''OR'''
|}
== See also ==
* [[QUERY]]
1,587
edits