|
|
|
|
|
The Procurement application allows searches using combinations of words, phrases and numbers. You may also use:
The AND operator has a higher precedence than OR.
The Procurement application retrieves all items containing the word "computer", "Computer", or "COMPUTER". Searches may be Case-sensitive or not Case-sensitive, depending on the database server installed for you system, and the language in which you are searching.
The Procurement application retrieves all items containing the exact phrase "computer monitor".
The Procurement application retrieves all items containing both the words "computer" and "monitor" (not necessarily adjacent), but not items containing only the word "computer", or only the word "monitor".
The Procurement application retrieves all items containing either the word "computer" or "monitor", or both (not necessarily adjacent).
The Procurement application retrieves all items containing the "computer", if they do not also contain the word "monitor".
The AND operator has a higher precedence than OR.
For example, these first three queries yield the same result:
Expressions inside parentheses are evaluated before the rest of the query so that you can use parentheses to nest AND, OR and NOT expressions within a query.
Noise Words include the definite and indefinite articles, "and", "or", other common conjunctions, and so on.
If used in a phrase, inside double quotation marks ("), noise words are treated as placeholders in queries and may be replaced with any other Noise Word.
Use double quotes (") to indicate that "and", "or" and "not" are not being used as operator keywords and should be considered part of a search phrase. For example:
The Procurement application retrieves all items containing both the words "computer" and "monitor" (not necessarily adjacent), but not items containing only the word "computer", or only the word "monitor".
The Procurement application retrieves only items containing a phrase connecting "computer" and "monitor" with any Noise Word, such as: "computer and monitor", "computer for monitor", "computer by monitor", and so on.
To search for a phrase containing a quotation, double the double quotes symbols around the word or phrase you want to be quoted. For example:
The Procurement application retrieves items containing "Computer" monitor" but not "computer monitor".
Only double quotes can be used and they must be in matching, opening and closing pairs. For example:
The Procurement application retrieves nothing, reporting an error because the opening quote was not matched by a closing quote.
The only acceptable wild card characters is the asterisk (*) symbol. It may be used to perform searches of these types:
The Procurement application retrieves all items containing words beginning with this fragment, such as: computer, complex, comparison, and so on (all of which begin with "comp".)
The Procurement application retrieves all items containing the specified fragments with other characters replacing the wild cards, such as: computer, composer, commuter and so on (all of which begin with "com" and end with "er".)
The Procurement application retrieves all items containing words with this stem even when they are spelled differently, such as: writing, writer, written, and so on, and also the word wrote, (which does not contain the word fragment "writ" but has the same stem.)
Note: This type of search is not supported in all languages.
The search response to a wildcard character may vary:
For example, for the search phrases H P or Hewl Pack, the Procurement application retrieves all items manufactured by Hewlett Packard.
For example, a search phrase such as th* would retrieve all items with the, this, that, and so on in the description. The Procurement application displays an error that your search phrase is likely to retrieve a large number of common words and suggests using a different phrase.
If a search using wild cards produces too many, too few or the wrong results, modify your search phrase and try again.
