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 | + | A QueryItem defines a single filter rule for the evaluation of the result collection of a [[Query]]. This filter rule has the following parameters related to filtering: |
| − | {| class="wikitable sortable" | + | {| class="wikitable sortable" style="width:70%" |
|- | |- | ||
! Parameter !! DataType !! Example(s) !! Comment | ! 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 | | OPERATOR || {{Text}} || =,<,>,>=,<= || value must correspond to an item of the QuerySearchItemOperator enumeration | ||
| Line 22: | Line 24: | ||
|- | |- | ||
| FILTERVALUE|| {{Text}} || Any || the value the objects are compared to | | 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 | | ISNULL|| {{Boolean}} || true / false|| searched for NULL values | ||
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 related to filtering:
| 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 |
