Search thresholds quick reference

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.

Examples showing use of the is exact match criteria for some Discrete, Logical, and Short Text attributes:

  • Material form is Particulate composite
  • Recycle is Yes
  • Report number is TR-614212

Note that exact match ("is") searches on Short Text Attributes is case-sensitive. For example, these two searches will not return the same results:

  • Principal component is titanium
  • Principal component is Titanium

Avoid using is 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. For example:

  • Storage Condition is one of Ambient, Controlled:Dry
  • Wear resistance rating is one of Good, Very good
is not

Records where the data has any value except the specified value. For example:

  • Transparency is not Opaque
  • Food contact is not No
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. Examples:

  • Comp. Young's modulus with temperature is at least 5.5
  • Magnetic type is at least Magnetic
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. Examples:

  • Density is at most 0.15 lb/in^3
  • Transparency is at most Opaque
contains

Records where the data contains the specified string. For example:

  • Tradenames contains duraplex
  • Index number contains 033
is between

Records where the data value is in the specified range. For example:

  • Al (aluminum) is between 0.1 and 10%
  • Thermal conductivity is between 50 and 100 W/m. °C
  • Issue date is between 1/1/2010 to 12/31/2020
is on, is on or after, is on or before
  • Records where the date is the same as the specified date. For example:
    Issue date is on 21/1/2000
  • Records where the date is after or the same as the specified date. For example:
    Date of Analysis is on or after 12/8/2016
  • Records where the date is before or the same as the specified date. For example:
    Forging date is on or before 6/3/1998
includes

Records where the data contains the selected value. For example:

Additive includes UV stabilizer
includes all of

Records where the data contains all of the selected values. For example:

Filler/reinforcement includes all of Bar, Extrusion, Rod
includes one of

Records where the data contains any one of the selected values. For example:

Available Forms includes one of Clad Plate, Clad Sheet
does not include

Records where the data does not contain the selected value. For example:

Additive does not include Plasticizer/oil