Advanced Search - Field Filters
Field Filters look at individual fields. You select the search field and the search condition from the drop down lists and type the search text below.
|Condition||Fields that satisfy the condition|
|contains||Contains the search text exactly as typed regardless of what precedes or follows.
Example, a search where Title contains "light" will find items with titles that contain "light", "moonlight" and "lighthouse".
|does not contain||Does not contain the search text.|
|does not match||See the matches condition below.|
|ends with||Ends with the search text.|
|is empty||Has no text.|
|is exactly||Exactly matches the search text (case-insensitive).
Example: A search where Title is exactly "baker island light" will find items where the title is "Baker Island Light" but not "Baker Island Light Station".
|is not empty||Contains text.|
|is not exactly||Does not exactly match the search text (case-insensitive).|
|matches||Note: Regular expressions are an advanced feature that are explained in detail in the MySQL documentation for Regular Expressions.
Matches a regular expression you specify.
One of the best uses of this condition is to find a small set of items that match any of a specific set of search values. You separate the values with a | (vertical bar).
Example: A search where Identifier matches "6045|13956|13447" will find just those three items.
Example: A search where Creator matches "^(soules|motenko)" will find items where the Creator fields starts with either "soules" or "motenko".
|starts with||Starts with the search text.
Be careful using this condition with the Location, Subject, and Type fields because they contain hierarchical values like "MDI, Bar Harbor". A search where Location starts with "Bar Harbor" will not return any results because the field starts with "MDI". Instead use Location contains "Bar Harbor".
Field Filter Notes:
- You can add additional fields to the filter by clicking the Add Field button.
- You can use the same field more than once. For example you could search where Location contains “MDI” AND Location does not contain “Bar Harbor”.
- When you specify multiple fields, the search logic evaluates them in top to bottom order and gives higher precedence to AND than to OR.