Difference between revisions of "QUERYITEM"
| Line 21: | Line 21: | ||
| 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 ''' | + | | 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 | | FILTERVALUE|| {{Text}} || Any || the value the objects are compared to | ||
| Line 34: | Line 34: | ||
== See also == | == See also == | ||
* [[QUERY]] | * [[QUERY]] | ||
| − | |||
| − | |||
Revision as of 15:44, 17 October 2019
 Query Item |
|
|---|---|
| Name | QUERYITEM |
| Namespace | System.Query |
| Internal Name | SystemObjects.QUERYITEM |
| TypeString | UBIK.Kernel.MetaClass |
| RuntimeType | UBIK.Kernel.QueryItem |
| Purpose | Configure query items |
| Version | 2+ |
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 |
