Difference between revisions of "QUERYITEM"
| (11 intermediate revisions by 2 users not shown) | |||
| Line 2: | Line 2: | ||
| title = Query Item | | title = Query Item | ||
| name = QUERYITEM | | name = QUERYITEM | ||
| − | | internalname = | + | | internalname = SystemObjects.{{PAGENAME}} |
| − | | namespace = System | + | | namespace = System.Query |
| image = [[File:SY_QUERYITEM.png|220px]] | | image = [[File:SY_QUERYITEM.png|220px]] | ||
| imagecaption = Query item | | imagecaption = Query item | ||
| purpose = Configure query items | | purpose = Configure query items | ||
| version = 2+ | | version = 2+ | ||
| + | | typestring = UBIK.Kernel.MetaClass | ||
| + | | runtimetype = UBIK.Kernel.QueryItem | ||
}} | }} | ||
| − | [[ | + | 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%" | ||
| + | |- | ||
| + | ! style="width:150px" | Parameter !! DataType !! Example(s) !! Comment | ||
| + | |- | ||
| + | | NAME || {{Text}} || Any || The name of the MetaProperty the filter value should be compared for. | ||
| + | |- | ||
| + | | OPERATOR || {{Text}} || =, <=, <, >, >=, != || The comparison operator. The 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 filter value; for an additional wildcard at the beginning of the filter value add '''%''' - if true, this overrides the OPERATOR configuration. | ||
| + | |- | ||
| + | | FILTERVALUE|| {{Text}} || Any || This filter value is compared to the property values (for the specified MetaProperty) of the objects 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 value to compare. Use '''-1''' for the standard value. | ||
| + | |- | ||
| + | | ISNULL|| {{Boolean}} || true / false|| True, if the query item should match for NULL values; if true, this overrides the LIKECOMPARISON and OPERATOR configuration. | ||
| + | |- | ||
| + | | LOGICALAND || {{Boolean}} || true / false || If true, the given QueryItem and its predecessor are logically joined using '''AND'''; otherwise using '''OR''' | ||
| + | |} | ||
| + | |||
| + | == See also == | ||
| + | * [[QUERY]] | ||
Latest revision as of 16:59, 3 December 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 | The name of the MetaProperty the filter value should be compared for. |
| OPERATOR | Text | =, <=, <, >, >=, != | The comparison operator. The 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 filter value; for an additional wildcard at the beginning of the filter value add % - if true, this overrides the OPERATOR configuration. |
| FILTERVALUE | Text | Any | This filter value is compared to the property values (for the specified MetaProperty) of the objects 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 value to compare. Use -1 for the standard value. |
| ISNULL | Boolean | true / false | True, if the query item should match for NULL values; if true, this overrides the LIKECOMPARISON and OPERATOR configuration. |
| LOGICALAND | Boolean | true / false | If true, the given QueryItem and its predecessor are logically joined using AND; otherwise using OR |
