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.
- 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
