1.3.4.3.2.  Full text search: Detailed search options
1.3.4.3.2.14. Logical operators
Prev  Next
1.3.4.3.2.14. Logical operators

  • Comparison 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:

    Sechskantschaube L>200

  • Link 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 specific term

      Examples:

      • Round cylinders shall be excluded.

        Zylinder NOT rund
oder
Zylinder !rund

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

        Handrad !(Form V)

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

      [Note]Note

      The AND operator can also be dropped.

      Schraube AND Schaft

ist gleichbedeutend mit

Schraube Schaft

      Examples on the AND operator 

      • 16.2 21 90

      • Sechskantschraube L = 400

        or

        Sechskantschraube AND L = 400

      • Sechskantschrauben AND >200

        Searching for hexagon bolts with any value greater than 200.

      • Sechskantschraube L>=140 L<=160
oder
Sechskantschraube L>=140 AND L<=160

      • Sechskantschraube L = 120 AND D = 22

      • IDNR>=23012001 AND IDNR<=23012025

    • OR: It is sufficient if a term occurs or a single 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
1.3.4.3.2.13. Number search with units (explicitly and implicitly) Home 1.3.4.3.2.15. Mixture of AND and OR - Parentheses