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 |