Advance
searching is very easy to do. Basically:
- Select the field(s) to search from the drop
list.
- Select an Operator
from the operator drop down list.
- Enter in a value to search.
- Hit the Search button.
Use the Reset button to
clear all fields. (Note - you must clear the any text in the Simple Search box manually) You can also Save
Searches
Boolean Searches (AND
OR)
Using AND OR examples:
Example 1 --
Item Name contains fork
OR Item Name
Contains shovel .
This will find all items that include the word fork
or shovel in the name such as Fork, Pitch Fork,
Garden Shovel, Shovel and so on.
Example 2 -- Item Description contains weed
And Item
Description Contains trimmer
This will find records with the words Weed
and Trimmer in the description field
such as "Power trimmer to cut big weeds and brush"
but it would not find any item descriptions that have
only the word weed in it or only the word trimmer such as "Toro
Trimmer" or "Weed Wacker"
Date
searching
When you select a field that is a "date" then the search "value
" criteria will change its format from a text field
to a date field. See figure below
Figure 1
