4.4.1.  Text search
4.4.1.14. Logical operators
Prev  Next

4.4.1.14. Logical operators

  • Comparison operators

    If you search with variables, you can use comparison operators, not only the actual-equal (=), but all common mathematical operators.

    • = : Is equal to

    • < : Smaller

    • > : Larger

    • <= : Smaller equals

    • >= : Greater than or equal to

    Example:

    Hexagonal blade L>200

  • Link operators

    You can also link terms and numerical values with "AND" or "OR" and exclude certain terms with "NOT".

    [Note]Note

    The search term is not case-sensitive.

    Operators such as AND, NOT, OR, on the other hand, must be capitalized.

    • NOT: Exclusion of a specific term

      Examples:

      • Round cylinders should be excluded.

        Cylinder NOT round
or
Cylinder ! round

        [Note]Note

        No space is allowed between the exclamation mark (!) and the term to be excluded.

      • If you want to exclude a sequence of terms, you must put them in brackets.

        Handwheel !( Form V )

    • AND: All terms must occur or all conditions must be fulfilled.

      [Note]Note

      The AND operator can also be omitted.

      Screw AND shank

is synonymous with

Screw Shaft

      Examples of the AND operator 

      • 16.2 21 90

      • Hexagon Bolt L = 400

        or

        Hexagon Bolt AND L = 400


      • Hexagon head screws AND >200

        The system searches for hexagon bolts with any value greater than 200.

      • Hexagon Bolt L>=140 L<=160
or
Hex Bolt L>=140 AND L<=160


      • Hex Bolt L = 120 AND D = 22


      • IDNR>=23012001 AND IDNR<=23012025

    • OR: It is sufficient if a term occurs or a single condition is fulfilled.

      Example of the OR operator 

      • Hexagon Bolt OR Cap Bolt

        The result therefore contains both hexagon head screws and cheese head screws.

      • ( Hexagon bolt ) OR ( Head cap bolt )

        is equivalent to

        Hexagon bolt OR Head cap bolt

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

      For further details, see the next point.

Prev Up Next
4.4.1.13. Number search with units (explicit and implicit) Home 4.4.1.15. Mixture of AND and OR - bracket replacement