Jump to: navigation, search

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 = QueryItem
+
| internalname = SystemObjects.{{PAGENAME}}
| namespace = System.Query<br/>Custom.Query
+
| 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
 
}}
 
}}
  
[[Category:System MetaClasses]]
+
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

IC METACLASS.gif 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

See also