Difference between revisions of "HowTo:Create a new QueryItem"
| (5 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | The [[ | + | 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]] | ||
# 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 at least name, description | + | # Set the [[Query#Query, QueryItem|FILTERVALUE]] (the property value to filter by - you can use "%" as a wild card) |
| − | # Save the changes | + | # 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]] (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]] (true, if the comparison operator "LIKE" should be used - if true, this overrides the OPERATOR) | ||
| + | # 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]] (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]] | ||
| + | # Save the changes with {{key press|Ctrl|S}} or the save command | ||
==See also== | ==See also== | ||
| − | * [[Create a new Query]] | + | * [[HowTo:Create a new 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.
- Navigate to the MetaClass QueryItem via the Class Browser
- Create a new instance using the Bulk Editor
- Set the FILTERVALUE (the property value to filter by - you can use "%" as a wild card)
- Set the INDEX (the index of the property value to filter - use "-1" for the standard value)
- Set the ISNULL (true, if the value to filter by should be NULL - if true, this overrides the LIKECOMPARISON and the OPERATOR)
- Set the LIKECOMPARISON (true, if the comparison operator "LIKE" should be used - if true, this overrides the OPERATOR)
- Set the LOGICALAND (true, if the previous query item and this one both must match; false, if one of them is sufficient)
- Set the 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.
- Save the changes with Ctrl+S or the save command
