Tip
Searches for any results where the field value contains your text.
This is a
wildcard field.
Use an asterisk (*) to perform a starts with or ends
with search, or surround with quotes for an exact match e.g. Searching for
Abc |
finds all starting with "Abc" |
Abc* |
as above, starts with |
*Abc |
finds all ending with "Abc" |
"Abc" |
finds exact match of "Abc" |
This is a date range field. Enter a range separated by 'to' e.g. 31/05/2009 to 25/12/2009
This is a number range field and supports the use of plus and minus (+, -).
Use n+
to indicate "n or more", e.g. 7+ for 7 or more
Use n-
to search for "n or less" e.g. 3- for 3 or less
Use n-n
to specify an inclusive range e.g. 3-7
Use n
to search exact
Also works with decimal ranges if applicable