You can combine two or more queries using one of the boolean operators
in the following table. Using these operators you could build a query
such as:
{Scan time} = "3" AND {Security Area 1} = "Packaging"
to display all the blocks in security area Packaging with a scan time
of 3 seconds.
Boolean Operators
|
The operator...
|
Instructs Database Manager
to...
|
Example
|
|
AND
|
Select the block when both query A and query B are
true.
|
A AND B
|
|
OR
|
Select the block if either query A or query B is true.
|
A OR B
|
|
NOT
|
Invert query. If query A is true, its value becomes
false.
|
NOT A
|
|
NOR
|
Select the block when both query A and query B are
false.
|
A NOR B
|
|
XOR
|
Select the block if query A and query B are not both
true or both false.
|
A XOR B
|
|
NAND
|
Select the block when query A and query B are not
both true.
|
A NAND B
|
See Also
