Jump to: navigation, search

Difference between revisions of "HowTo:Create a new QueryItem"


(See also)
 
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]]
 
# 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]]
 
# 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
 
# 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]]
 
# 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]]
 
* [[Query]]
  
 
+
[[Category:How-To|Create a new QueryItem]]
 
+
[[Category:How-To]]
+

Latest revision as of 16:13, 3 December 2019

The QueryItem is a single filter criterion filtered by a Query.

  1. Navigate to the MetaClass QueryItem via the Class Browser
    Query
  2. Create a new instance using the Bulk Editor
    Query
  3. Set the FILTERVALUE (the property value to filter by - you can use "%" as a wild card)
  4. Set the INDEX (the index of the property value to filter - use "-1" for the standard value)
  5. Set the ISNULL (true, if the value to filter by should be NULL - if true, this overrides the LIKECOMPARISON and the OPERATOR)
  6. Set the LIKECOMPARISON (true, if the comparison operator "LIKE" should be used - if true, this overrides the OPERATOR)
  7. Set the LOGICALAND (true, if the previous query item and this one both must match; false, if one of them is sufficient)
  8. Set the OPERATOR (the comparison operator, i.e., one of the following: "=", "!=", ">", ">=", "<", "<=" - only relevant if neither ISNULL nor LIKECOMPARISON is true)
  9. Set at least name, description
  10. The required QueryItem's must be added to the Query with the Relation Editor.
    View
  11. Save the changes with Ctrl+S or the save command


See also