Difference between revisions of "HowTo:Create a new QueryItem"
(Created page with " ==See also== * Create a new Query How-To") |
|||
| (8 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| + | 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 the [[Query#Query, QueryItem|FILTERVALUE]] (the property value to filter by - you can use "%" as a wild card) | |
| + | # 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== | ||
| + | * [[HowTo:Create a new Query]] | ||
| + | * [[Query]] | ||
| − | [[Category:How-To]] | + | [[Category:How-To|Create a new QueryItem]] |
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
