HowTo:Create a new QueryItem - Revision history

NWE at 16:13, 3 December 2019

2019-12-03T16:13:19Z

KNO: /* See also */

2015-01-27T14:55:37Z

‎See also

KNO: moved Create a new QueryItem to HowTo:Create a new QueryItem

2015-01-27T14:55:24Z

moved Create a new QueryItem to Create a new QueryItem

PFR at 09:52, 8 January 2014

2014-01-08T09:52:24Z

PFR at 09:46, 8 January 2014

2014-01-08T09:46:38Z

PFR at 09:21, 8 January 2014

2014-01-08T09:21:31Z

JKN at 07:34, 8 January 2014

2014-01-08T07:34:37Z

PFR at 15:01, 7 January 2014

2014-01-07T15:01:34Z

PFR at 14:58, 7 January 2014

2014-01-07T14:58:14Z

PFR: Created page with " ==See also== * Create a new Query Category:How-To"

2014-01-07T09:31:12Z

Created page with " ==See also== * Create a new Query How-To"

New page

==See also==
* [[Create a new Query]]

[[Category:How-To]]

@@ Line 3: / Line 3: @@
 # Navigate to the [[MetaClass]] ''QueryItem'' via the ''[[Class Browser]]''<br/>[[File:UI queryitem 01.PNG|220 px|border|alt=Query|Query]]
 # Create a new instance using the ''[[Bulk Editor]]''<br/>[[File:UI queryitem 02.PNG|990 px|border|alt=Query|Query]]
-# Set the [[Query#Query, QueryItem|FILTERVALUE]]
+# Set the [[Query#Query, QueryItem|FILTERVALUE]] (the property value to filter by - you can use "%" as a wild card)
-# Set the [[Query#Query, QueryItem|INDEX]]
+# Set the [[Query#Query, QueryItem|INDEX]] (the index of the property value to filter - use "-1" for the standard value)
-# Set the [[Query#Query, QueryItem|ISNULL]]
+# Set the [[Query#Query, QueryItem|ISNULL]] (true, if the value to filter by should be NULL - if true, this overrides the LIKECOMPARISON and the OPERATOR)
-# Set the [[Query#Query, QueryItem|LIKECOMPARISON]]
+# Set the [[Query#Query, QueryItem|LIKECOMPARISON]] (true, if the comparison operator "LIKE" should be used - if true, this overrides the OPERATOR)
-# Set the [[Query#Query, QueryItem|LOGICALAND]]
+# Set the [[Query#Query, QueryItem|LOGICALAND]] (true, if the previous query item and this one both must match; false, if one of them is sufficient)
-# Set the [[Query#Query, QueryItem|OPERATOR]]
+# Set the [[Query#Query, QueryItem|OPERATOR]] (the comparison operator, i.e., one of the following: "=", "!=", ">", ">=", "<", "<=" - only relevant if neither ISNULL nor LIKECOMPARISON is true)
 # Set at least name, description
 # The required QueryItem's must be added to the Query with the ''[[Relation Editor]]''.<br/>[[File:UI queryitem 03.PNG|330 px|border|alt=View|View]]
@@ Line 18: / Line 18: @@
 * [[Query]]
+[[Category:How-To|Create a new QueryItem]]
-−
 [[Category:How-To]]

@@ Line 15: / Line 15: @@
 ==See also==
-* [[Create a new Query]]
+* [[HowTo:Create a new Query]]
 * [[Query]]

@@ Line 3: / Line 3: @@
 # Navigate to the [[MetaClass]] ''QueryItem'' via the ''[[Class Browser]]''<br/>[[File:UI queryitem 01.PNG|220 px|border|alt=Query|Query]]
 # Create a new instance using the ''[[Bulk Editor]]''<br/>[[File:UI queryitem 02.PNG|990 px|border|alt=Query|Query]]
-# Set the '''FILTERVALUE'''
+# Set the [[Query#Query, QueryItem|FILTERVALUE]]
-# Set the '''INDEX'''
+# Set the [[Query#Query, QueryItem|INDEX]]
-# Set the '''ISNULL'''
+# Set the [[Query#Query, QueryItem|ISNULL]]
-# Set the '''LIKECOMPARISON'''
+# Set the [[Query#Query, QueryItem|LIKECOMPARISON]]
-# Set the '''LOGICALAND'''
+# Set the [[Query#Query, QueryItem|LOGICALAND]]
-# Set the '''OPERATOR'''
+# Set the [[Query#Query, QueryItem|OPERATOR]]
 # Set at least name, description
 # The required QueryItem's must be added to the Query with the ''[[Relation Editor]]''.<br/>[[File:UI queryitem 03.PNG|330 px|border|alt=View|View]]

@@ Line 1: / Line 1: @@
-The [[Queryitem]] is a single filter criterion filtered by a [[Query]].
+The [[QueryItem]] is a single filter criterion filtered by a [[Query]].
 # Navigate to the [[MetaClass]] ''QueryItem'' via the ''[[Class Browser]]''<br/>[[File:UI queryitem 01.PNG|220 px|border|alt=Query|Query]]
 # Create a new instance using the ''[[Bulk Editor]]''<br/>[[File:UI queryitem 02.PNG|990 px|border|alt=Query|Query]]
-# Set at least name, description and filtered metaclass ''Query''
+# Set the '''FILTERVALUE'''
-# Save the changes
+# Set the '''INDEX'''

← Older revision		Revision as of 07:34, 8 January 2014
Line 1:		Line 1:
−	The [[Queryitem]] is a filter criterion ~~after being~~ filtered in a [[Query]].	+	The [[Queryitem]] is a single filter criterion filtered by a [[Query]].

	# Navigate to the [[MetaClass]] ''QueryItem'' via the ''[[Class Browser]]''<br/>[[File:UI queryitem 01.PNG\|220 px\|border\|alt=Query\|Query]]		# Navigate to the [[MetaClass]] ''QueryItem'' via the ''[[Class Browser]]''<br/>[[File:UI queryitem 01.PNG\|220 px\|border\|alt=Query\|Query]]

← Older revision	Revision as of 14:55, 27 January 2015
(No difference)

← Older revision		Revision as of 15:01, 7 January 2014
Line 1:		Line 1:
	The [[Queryitem]] is a filter criterion after being filtered in a [[Query]].		The [[Queryitem]] is a filter criterion after being filtered in a [[Query]].
		+
		+	# Navigate to the [[MetaClass]] ''QueryItem'' via the ''[[Class Browser]]''<br/>[[File:UI queryitem 01.PNG\|220 px\|border\|alt=Query\|Query]]
		+	# Create a new instance using the ''[[Bulk Editor]]''<br/>[[File:UI queryitem 02.PNG\|990 px\|border\|alt=Query\|Query]]
		+	# Set at least name, description and filtered metaclass ''Query''
		+	# Save the changes

← Older revision		Revision as of 14:58, 7 January 2014
Line 1:		Line 1:
		+	The [[Queryitem]] is a filter criterion after being filtered in a [[Query]].
		+

	==See also==		==See also==