Specifications

64 Searching the Data Source
ID Works Standard and Enterprise Version 5 Operator’s Guide
Search Rules
The rest of this chapter lists the constraint rules available for each
type of Production Form field, gives the required Constraint Detail for
each field type-constraint rule combination, and explains how the
Field Constraint options affect the constraint. Use this information for
reference if your searches do not return the results you expect.
Text Fields
Possible constraints for Production Form text fields or list fields
connected to a text database column are:
= Constraint Rule
Use the = rule to create a single-value text match. It supports using
the SQL wildcard characters % and _. If you do not choose any of the
options described below, the = rule is equivalent to the support
offered in the Quick Search dialog box. If you use a wildcard
character, the actual query will contain a LIKE operator. Example:
where EMPLOYEE.LASTNAME LIKE ‘Jon%’
If you do not use a wildcard character, the query will contain an =
operator. Example: where EMPLOYEE.LASTNAME = ‘Jones’
Constraint Rule Required Detail
Supported Options
Exclude Case Insensitive NULL
= A value Yes Yes Yes
IN Multi-value
Constraint List
Yes
*
Yes
†
Yes
IS NULL None No No No
IS NOT NULL None No No No
* Excludes entire list.
† Applies to entire list.