Advanced Search Tips

At its simplest, a search query can be just a word (see Basic Search Tips for more info). But with the advanced features described below, you can refine your search to give you more complete results.

  • For numeric fields, use one of the following operators: equals (=), less than (<), greater than (>), less than or equal to (<=), or greater than or equal to (>=).
    Example - type @department = 63 to match records with the department field set to 63.
  • For date fields, search for a date range or use the relative date values: years (-ny), months(-nm), weeks (-nw), or days (-nd).
    Examples - type @DateEntered < 98/12/01 AND @DateEntered > 98/10/31 to find records with a DateEntered field value in November 1998, or type @DateEntered < -1w to find all records with a DateEntered field value within the last week.

You can search any of the database fields listed on the search page:

  • To search the default field, type your query and then click Search.
  • To search a different field, type the name of the field before the query, and then click Search.

Examples - type @Author Smith to match records with the word Smith in the Author field, type @documentID > 1000 to find all records with a documentID column greater than 1000, or @all soccer to find records with the word soccer in any indexed field.

More Search Tip Topics: