Search thresholds

For each search criteria in your query, you can specify a search threshold which identifies the value or value range you are interested in, for example, is, is at least, is between, is not.

The search threshold you can choose depends on the Attribute data type. The different threshold type options have the following effects when used in searches:

Threshold option Search returns
exists Records where there is data for this Attribute.
does not exist Records where there is no data for this Attribute.
is

Records where the data value is exactly equal to the specified value.

Note: Exact match ("is") searches on Short Text Attributes are case-sensitive. For example, these two searches will not return the same results:
  • Principal component is titanium
  • Principal component is Titanium

Avoid using exact matching for numerical data, because it will give a result only for the true value of the data, not the rounded display number you see on the datasheet. For example, if on the datasheet you see "17.7" but the real value is "17.68917", an exact match search for "is 17.7" will not return a match.
is one of

Records where the data value is one of the selected values.

is not

Records where the data has any value except the specified value.

For Tabular data, the value may not occur in any of the rows.
is at least

Records where the data value is greater than or equal to the specified value. For Attributes with a set of ordered values, returns records where the value is equal to or higher than the specified value.

is at most

Returns records where the data value is equal to or less than the specified value. For Attributes with a set of ordered values, returns records where the value is lower than or equal to the specified value.

contains

Records where the data contains the specified string.

is between

Records where the data value is in the specified range.

is on, is on or after, is on or before
  • Records where the date is the same as the specified date.
  • Records where the date is after or the same as the specified date.
  • Records where the date is before or the same as the specified date.
includes

Records where the data contains the selected value.

includes all of

Records where the data contains all of the selected values.
includes one of

Records where the data contains any one of the selected values.
does not include

Records where the data does not contain the selected value.