Skip to content

Specify Forums

Personal tools
You are here: Home » Frequent User Questions » Using Operators in Specify Searches

Using Operators in Specify Searches

Document Actions

When creating a query, the use of operators is vital in establishing your criteria.
An operator is a method of comparision to the value you enter. For example, if you wanted a query that returned all records with catalog numbers greater than 100, you would say:

Catalog Number > 100

The greater-than sign ">" is the operator.

Below is a listing of all the operators used in Specify:

= (Equal to)
The field must match the input data exactly.

< (Less than)
The number must be less than the input data.

> (Greater than)
The number must be greater than the input data.

Empty
The field must be empty.

On
The field must contain the exact input date.

Before
The event must have occured before the input date.

After
The event must have occured after the input date.

Between (Dates)
The event must have occured between the input dates.

Between (Number)
The number must fall within the input range (e.g. 1, 5).

Yes
The Yes/No field must be Yes.

No
The Yes/No field must be No.

Don't Care
It does not matter what is in the Yes/No field--Yes, No, or empty.

Like
You can make use of wild card character "*"  to search.
(e.g. ja* would be true for "jar" and "January").

Contains
The text field must contain the input data.

In
The field must be one of the comma-delimited inputs.
(e.g. 4, 8, 9 would be true for 4 and 9, but not for 5).

Not
The Not check box returns the opposite.
(e.g. Not > 100 would return anything equal to or less than 100).
(e.g. Not On 1/12/2000 would return anything that did not occur on January 12, 2000).

See "Operators" under "Query Data" for additional documentation.
Back to Frequent User Questions

Created by cj
Last modified 2007-03-04 03:39 PM
 

Powered by Plone

This site conforms to the following standards: