Selection Criteria
Type in Selection Criteria to specify results for any Data Name. A data field can be subject to a selection criteria, but not display the data in the Query results if the Display checkbox is left unchecked.
Selection Criteria must be typed exactly as shown in these examples:
| Selection Criteria | Definition | Examples |
| = | Equal | = 'Product Quality' |
| < | Less Than | < 500 |
| > | Greater Than | > 10040 |
| Not = | Not Equal | Not = 10030 |
| Not < | Not Less Than | Not < 3 |
| Not > | Not Greater Than | Not > 10 |
| <= | Less Than Or Equal To | <= 500 |
| >= | Greater Than Or Equal To | >= 500 |
| Between nnn and nnn | Between nnn and nnn | Between 1/1/2003 and 3/31/2003 |
| Now (for SQL) | Today minus X days | >= (getdate()-7) |
| nnn,nnn,nnn | Comma Delmited Series | 10030,10031,10032 |
| or | nnn or nnn | 10030 or 10031 or 10032 |
| and | nnn and nnn | 10030 and 10032 |
| Like %nnn% | Wildcard search | Like %defect% |
| "" | Null or empty field (double quotes, no space) | "" |
Equal
The default selection condition is equal to the specified value or equal to a list of values. Use of the ‘=’ symbol is optional.
Multiple Values
When multiple values are specified, the values can be separated by commas or by the word ‘ or ’.
Wildcards
A Wildcard selection criteria is available using the SQL “Like” command. When using the Like command, the selection criteria can be prefixed and/or suffixed with a "%" sign. A “%” prefix and suffix (i.e. Like %defect%) means select all records containing the word "defect" anywhere in the specified column. A "%" prefix (i.e. Like %defect) means select records where the specified column ends in the word "defect". A “%” suffix (i.e. Like defect%) means select records where the specified column begins with the word “defect”. If the search string includes embedded spaces or punctuation, the search string, including % signs, must be enclosed within quotes, (i.e. Like "%on arrival%" Like "%error, bug%").
Dates
Dates must be formatted including slashes, MM/DD/YYYY. When there is more than one word in the selection statement the data must be contained in single quotes. For example = ‘Product Quality’. If the selection statement contains an apostrophe, the data must be contained in double quotes.
More Than One Word
To search correctly when a term contains two or more words as part of the Selection Criteria, it must be contained in quotes. For example, to search on the two-word term Product Quality, the format is, = 'Product Quality'. If the Selection Criteria contains an apostrophe, the term must be contained in double quotes.
See also