Difference between revisions of "QUERYITEM"
| (5 intermediate revisions by 2 users not shown) | |||
| 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: |
| − | {| class="wikitable sortable" | + | {| class="wikitable sortable" style="width:70%" |
|- | |- | ||
| − | ! Parameter !! DataType !! Example(s) !! Comment | + | ! 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 == | == See also == | ||
* [[QUERY]] | * [[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 |
