Difference between revisions of "QUERYITEM"
| Line 12: | Line 12: | ||
}} | }} | ||
| − | A QueryItem defines a single filter rule for the evaluation of the result collection of a [[Query]]. This filter rule has the following parameters | + | A QueryItem defines a single filter rule for the evaluation of the result collection of a [[Query]]. This filter rule has the following parameters: |
{| class="wikitable sortable" style="width:70%" | {| class="wikitable sortable" style="width:70%" | ||
|- | |- | ||
Revision as of 10:39, 24 March 2015
 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 |
