5.3.  Text Search
5.3.13. Logical operators
Prev  Next

5.3.13. Logical operators

  • Relational operators

    When searching with variables, you can use logical operators, not only "equal" (=), but all usual mathematical operators.

    • = : Equal

    • < : Less

    • > : Greater

    • <= : Less or equal

    • >= : Greater or equal

    Example:

    Hexagon bolt L>200

  • Linking operators

    Furthermore you can combine terms and numerical values with "AND" or "OR" and exclude certain terms with "NOT".

    [Note]Note

    Upper or lower case makes no difference for the search term.

    Operators such as AND, NOT, OR have to be upper case.

    • NOT: Exclusion of a certain term

      Examples:

      • Round cylinders shall be excluded.

        cylinder NOT round
or
cylinder !round

        [Note]Note

        Between exclamation mark (!) and the term to be excluded, there is no empty space allowed.

      • If a sequence of several terms shall be excluded, you have to set them into parentheses.

        Hand wheel !(Form V)

    • AND: All terms have to exist and all conditions have to be fulfilled.

      [Note]Note

      The AND operator can also be dropped.

      bolt shank

equals

bolt AND shank

      Examples on the AND operator 

      • 16.2 21 90

      • Hexagon bolt L = 400

        or

        Hexagon bolt AND L = 400

      • Hexagon bolts AND >200

        Searching for hexagon bolts with any value greater than 200.

      • Hexagon bolt L>=140 L<=160
or
Hexagon bolt L>=140 AND L<=160

      • Hexagon bolt L = 120 AND D = 22

      • IDNR>=23012001 AND IDNR<=23012025

    • OR: It is sufficient if one term exists or one condition is fulfilled.

      Examples on the OR operator 

      • Sechskantschraube OR Zylinderschraube

        The result will include both "Sechskantschrauben" and "Zylinderschrauben".

      • (Hexagon bolt) OR (Head cap bolt)

        is equivalent to

        Hexagon bolt OR Head cap bolt

        The brackets are dispensable. The empty space is equivalent to AND.

      For more details please see next point.

Prev Up Next
5.3.12. Number search with units (explicitly and implicitly)  Home 5.3.14. Mixture of AND and OR - Parentheses