|
|
|
|
|
|
|
|
|
| Previous | Next | Contents | Index | Navigation | Glossary | Library |
| 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 | |
Attention: 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.
Attention: 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.
| Previous | Next | Contents | Index | Navigation | Glossary | Library |