QUERYITEM - Revision history

NWE at 16:59, 3 December 2019

2019-12-03T16:59:29Z

NWE at 15:44, 17 October 2019

2019-10-17T15:44:34Z

KNO at 10:40, 24 March 2015

2015-03-24T10:40:25Z

KNO at 10:40, 24 March 2015

2015-03-24T10:40:12Z

KNO at 10:39, 24 March 2015

2015-03-24T10:39:24Z

KNO at 10:39, 24 March 2015

2015-03-24T10:39:15Z

KNO at 10:34, 24 March 2015

2015-03-24T10:34:30Z

KNO at 10:26, 24 March 2015

2015-03-24T10:26:11Z

KNO at 13:51, 23 March 2015

2015-03-23T13:51:46Z

KNO: Text replacement - "[[Category:System MetaClasses" to "[[Category:Metaclasses"

2015-02-03T13:57:44Z

Text replacement - "[[Category:System MetaClasses" to "[[Category:Metaclasses"

@@ Line 17: / Line 17: @@
 ! style="width:150px" | Parameter !! DataType !! Example(s) !! Comment
 |-
-| NAME || {{Text}} || Any || Name of MetaProperty the filter values should be searched in
+| NAME || {{Text}} || Any || The name of the MetaProperty the filter value should be compared for.
 |-
-| OPERATOR || {{Text}} || =,<,>,>=,... || value must correspond to an item of the QuerySearchItemOperator enumeration
+| 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 filtervalue; for an additional wildcard at the beginning of the filter value add '''%'''
+| 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 || the value the objects are compared to
+| 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 || property has index values and filtering should consider a certain index
+| INDEX || {{Integer}} || Any || Specifies the index of the property value to compare. Use '''-1''' for the standard value.
 |-
-| ISNULL|| {{Boolean}} || true / false|| searched for NULL values
+| 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'''
+| LOGICALAND || {{Boolean}} || true / false || If true, the given QueryItem and its predecessor are logically joined using '''AND'''; otherwise using '''OR'''
 |}
 == See also ==
 * [[QUERY]]

@@ Line 21: / Line 21: @@
 | OPERATOR || {{Text}} || =,<,>,>=,... || 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 filtervalue; for an additional wildcard at the beginning of the filter value add '''*'''
+| 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 filtervalue; for an additional wildcard at the beginning of the filter value add '''%'''
 |-
 | FILTERVALUE|| {{Text}} || Any || the value the objects are compared to
@@ Line 34: / Line 34: @@
 == See also ==
 * [[QUERY]]

@@ Line 19: / Line 19: @@
 | NAME || {{Text}} || Any || Name of MetaProperty the filter values should be searched in
 |-
-| OPERATOR || {{Text}} || =,<,>,>=,<= || value must correspond to an item of the QuerySearchItemOperator enumeration
+| OPERATOR || {{Text}} || =,<,>,>=,... || 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 filtervalue; for an additional wildcard at the beginning of the filter value add '''*'''

@@ Line 15: / Line 15: @@
 {| class="wikitable sortable" style="width:70%"
 |-
-! Parameter !! DataType !! Example(s) !! Comment
+! style="width:150px" | Parameter !! DataType !! Example(s) !! Comment
 |-
 | NAME || {{Text}} || Any || Name of MetaProperty the filter values should be searched in

@@ 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 following parameters related to filtering:
+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%"
 |-

@@ Line 12: / Line 12: @@
 }}
-A QueryItem defines a single filter rule for the evaluation of the result collection of a [[Query]]:
+A QueryItem defines a single filter rule for the evaluation of the result collection of a [[Query]]. This filter rule has the followig parameters:
-* OPERATOR
+{| class="wikitable sortable"
-e.g. “=”
+|-
-* LIKECOMPARISON
+! Parameter !! DataType !! Example(s) !! Comment
-is the given item a “LIKE” filter criteria (wildcard is added to the filtervalue)
+|-
-* FILTERVALUE
+| OPERATOR || {{Text}} || =,<,>,>=,<= || value must correspond to an item of the QuerySearchItemOperator enumeration
-the value the objects are compared to
+|-
-* ISNULL
+| 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 filtervalue; for an additional wildcard at the beginning of the filter value add '''*'''
-searched for NULL values
+|-
-* LOGICALAND
+| FILTERVALUE|| {{Text}} || Any || the value the objects are compared to
-is there a logical AND relation between the given QueryItem and its predecessor (TRUE) or an OR relation (false)
+|-
 == See also ==

@@ Line 11: / Line 11: @@
 | runtimetype = UBIK.Kernel.QueryItem
 }}
 == See also ==

@@ Line 2: / Line 2: @@
 | title = Query Item
 | name = QUERYITEM
-| internalname = QueryItem
+| internalname = SystemObjects.{{PAGENAME}}
-| namespace = System.Query<br/>Custom.Query
+| namespace = System.Query
 | image = [[File:SY_QUERYITEM.png|220px]]
 | imagecaption = Query item
 | purpose = Configure query items
 | version = 2+
 }}
 [[Category:Metaclasses]]

← Older revision		Revision as of 13:57, 3 February 2015
Line 10:		Line 10:
	}}		}}

−	[[Category:~~System MetaClasses~~]]	+	[[Category:Metaclasses]]