Specifications

Searching the Data Source 59
ID Works Standard and Enterprise Version 5 Operator’s Guide
select a constraint rule, appropriate Field Constraint and Constraint
Detail selections become available for the current rule. Constraint
rules available for each Production Form field type, constraint values
required for those rules, and other details are given in “Search Rules”
on page 64.
Definitions of potential selections in the Field Constraint area are:
Include NULL values — If selected, records with null values in the
field (no information in the database column) will be included in the
search results.
Match text case-insensitive — If selected, case will be ignored. For
example, if you enter Smith for the Constraint value, records
containing “Smith”, “smith”, and “SMITH” (as well as other uppercase
and lowercase combinations of these letters) will be included in the
search results. Use this option when the database you are connected
to is case sensitive and capitalization in the database may be
inconsistent. This selection has no effect if the database is not case
sensitive.
Exclude constraint detail — If selected, all records that do not
match the Constraint value will be included in the search results.
Use this option when it is easier to define records that should not be
included.
In the Constraint Detail area, you may be required to enter
information in Constraint value only, in Constraint value and
Ending constraint value, or in the Multi-value Constraint List area. If
the Production Form field you selected is connected to a date type
database column, the Constraint value and Ending constraint
value have an arrow at the right side of the field. You can click the
arrow to select a date from a calendar or type a date in the field.
Using the Multi-value Constraint List
To select records that match any of a number of criteria (for example,
to select records for employees living in New York, London, or
Amsterdam), select the IN constraint rule. The Insert button in the
Multi-value Constraint List area becomes available. When you click
Insert, the Constraint List dialog box opens. Here you enter
constraint criteria (for example, Amsterdam to select employees living
in Amsterdam). When you click OK, the Constraint List dialog box
closes and the constraint you entered appears in the list of
constraints. You can insert as many constraints as necessary. You