This appendix explains how to query quality results.
This appendix covers the following topics:
You can query to find specific quality results using the Find Results window or by using the Show Results Where region.
The Find Results window can be invoked as you are:
The Show Results Where region automatically appears as you are:
Quality results can be found using any combination of selection criteria. For instance, you can select quality results that were entered on a specific date, by a specific user, and were assigned the same collection number.
To enter search criteria:
In the Find Results window or the Show Results Where region, select the Collection Element to use for your query.
Select the query Condition (operator). See: Query Operators.
If the condition selected requires a range, enter both the From and To value. If the condition requires a single value, enter only the From value. If the condition (e.g., is entered) requires a null character, do not enter anything. To create an In or Not in List, see Creating In and Not In Lists.
Repeat steps 1 through 3 until all selection conditions are entered.
If you are using the Find Results window, choose the Find button to display all quality results that meet the specified selection criteria. If you are using the Show Results Where region, the quality results that meet the specified selection criteria are used to create your descriptive statistic view, chart, or report.
To clear search criteria from the Find Results window
From the Find Results window, choose Clear to clear the current search criteria so you can enter new search criteria.
Important: Clearing the Find Results window does not clear the results records retrieved, only the conditions of your query. If you want to clear the results records, you must choose Clear Block from the Edit Menu.
To close the Find Results window:
The Find Results window remains open after you perform a search. Choose Close from the Control menu of the Find Results window to cancel Query Find.
Related Topics
Entering Quality Results Directly
You can use query operators in your search criteria to restrict your search to the information you need. The query operators you can use in most fields are presented in the following table:
| Query Operator | Meaning | Example Expression |
|---|---|---|
| equals (=) | Select only those records that are equal to the From value | Defect Code = 3 |
| is not (<>) | Select only those records that are not equal to the From value | To Department = Assembly |
| less than (<) | Select only those records that are less than the From value | Quantity < 500 |
| at most (<=) | Select only those records that are less than or equal to the From value | Quantity Rejected <= 5 |
| at least (>=) | Select only those records that are greater than or equal to the From value | Quantity Passed >= 10 |
| greater than (>) | Select only those records that are greater than the From value | Job > 14526 |
| between | Select only those records that are between the From and To values | Revision A02 and Revision A04 |
| outside of | Select only those records that are less than the From and greater than the To values | Cause Code 10 and Cause Code 20 |
| is empty | Select only those results that have no value | Not Applicable |
| is entered | Select only those records that have a value | Not Applicable |
Important: When you use the between query operator, the search criterion "between value 1 and value 2" retrieves all records containing values between and including value 1 and value 2. The same applies to dates. For example, the search criteria "between '01-JAN-96' and '01-MAR-96'" retrieves all records with dates between and including 01-JAN-96 and 01-MAR-96.
Query operator expressions retrieve results according to the ordering rules for character fields and number fields. For example suppose you have the following fields values: 002, 003, 004, 005, 078, 123, 253, 441, 576, 775, 1274, 3298, 4451, 5600, 9578, 10500, 58437, and 70845.
These values are shown in the order you expect for numeric values, where 005 is between 004 and 078. If the field is defined as character, the search criteria "between 4 and 7" retrieves the values 441, 576, 4451, 5600, and 58437, which all start with characters between 4 and 7. The values 775 and 005 would not appear because 775 is lexically greater than 7, and 0 is lexically less than 4.
Important: When using Query Find, it may not be possible to determine whether a field is defined as character or numeric and you may have to experiment with different search criteria expressions to see what results are returned.
You can also choose and define "in" and "not in" list operators when:
and when defining collection triggers as you are Associating Transactions with Collection Plans.
Related Topics
In addition to the standard query operators (conditions) that can be used to select quality results, you can define custom "in" and "not in" list operators. See: Finding Quality Results.
The "in" record selection condition allows you to create a user-defined list of values. Only quality results values that match the values in this list are selected. The "not in" record selection condition also allows you to create a user-defined list of values. However in this instance, only quality results values that do not match the values in this list are selected.
To define "in" and "not in" lists of values for conditional results selection
From the query operators list, select the in or not in Condition. (Multiple) appears in the From field.
Position the cursor in the From field.
From the Edit Menu choose List of Values. The In List Value window appears.
Enter the Values in List.
The data type of the selected collection element restricts the data type of the values you can enter.