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".
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
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.
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.
![[Note]](images/note.png)