Difference between revisions of "QUERYITEM"
| Line 15: | Line 15: | ||
{| class="wikitable sortable" style="width:70%" | {| class="wikitable sortable" style="width:70%" | ||
|- | |- | ||
| − | ! Parameter !! DataType !! Example(s) !! Comment | + | ! style="width:150px" | Parameter !! DataType !! Example(s) !! Comment |
|- | |- | ||
| NAME || {{Text}} || Any || Name of MetaProperty the filter values should be searched in | | NAME || {{Text}} || Any || Name of MetaProperty the filter values should be searched in | ||
Revision as of 10:40, 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 |
