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 depend on the data type.

Operator Returns
exists Records where there is data for this Attribute.
does not exist Records where no data exists 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") search 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

You should avoid using "is" for numerical data, because it will give a hit 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 give a hit.

is one of

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

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

Returns records where the data has any value except the specified value.

  • 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.

  • 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.
  • Density is at most 0.15 lb/in^3
  • Transparency is at most Opaque
contains Records where the data contains the specified string.
  • Tradenames contains duraplex
  • Index number contains 033
is between Records where the data value is in the specified range.
  • Al (aluminum) is between 0.1 and 10%
  • Thermal conductivity is between 50 and 100 W/m. °C
  • Issue date is between 1/1/2000 to 12/31/2010
is on is on or after, is on or before  Records where the date is the same as the specified date:

Issue date is on 21/1/2000

Records where the date is after or the same as the specified date:

Date of Analysis is on or after 12/8/2016

Records where the date is before or the same as the specified date:

Forging date is on or before 6/3/1998
includes Records where the data contains the selected value:

Additive includes UV stabilizer

includes all of Records where the data contains all of the selected values:

Filler/reinforcement includes all of Bar, Extrusion, Rod

includes one of Records where the data contains any one of the selected values:

Available Forms includes one of Clad Plate, Clad Sheet

does not include Records where the data does not contain the selected value:

Additive does not include Plasticizer/oil