Difference between revisions of "QUERYITEM"

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+

Latest revision as of 16:59, 3 December 2019

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

@@ Line 2: / Line 2: @@
 | title = Query Item
 | name = QUERYITEM
-| internalname = QueryItem
+| internalname = SystemObjects.{{PAGENAME}}
 | namespace = System.Query
 | image = [[File:SY_QUERYITEM.png|220px]]
@@ Line 8: / Line 8: @@
 | purpose = Configure query items
 | 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]]