Specifications

68 Searching the Database
ID Works Basic Version 5 Operator’s Guide
All selected fields have data Constraint Rule
Use this rule to find records where an image exists for all image fields
that share this rule. Example: where (EMPLOYEE.FRONT IS NOT
NULL AND EMPLOYEE.RIGHT IS NOT NULL)
At least one selected field has data Constraint Rule
Use this rule to find records where at least one of the specified
images does not exist. Example: where (EMPLOYEE.FRONT IS
NULL OR EMPLOYEE.RIGHT IS NULL)
At least one selected field is empty Constraint Rule
Use this rule to find records where at least one of the specified
images exists. Example: where (EMPLOYEE.FRONT IS NOT NULL
OR EMPLOYEE.RIGHT IS NOT NULL)
All selected fields are empty Constraint Rule
Use this rule to find records where none of the specified images
exists. Example: where (EMPLOYEE.FRONT IS NULL AND
EMPLOYEE.RIGHT IS NULL)