Specifications

Searching the Data Source 67
ID Works Standard and Enterprise Version 5 Operator’s Guide
Numeric Fields
Possible constraints for Production Form auto sequence fields, print
count fields, list fields, and text fields connected to a numeric
database column are:
= Constraint Rule
Use the = rule to match an exact value. Example:
where EMPLOYEE.DNMBR = 716
Exclude Option
If you select Exclude constraint detail, the search will return all
records with values that do not match the value you entered.
Example: where EMPLOYEE.DNMBR <> 716
NULL Option
If you select Include NULL values, the search will return all records
with NULL values in addition to records that contain the value you
entered. Example: where ((CARD.PRINTCOUNT = 0) OR
(CARD.PRINTCOUNT IS NULL))
Constraint Rule Required Detail
Supported Options
Exclude Case Insensitive NULL
= A value Yes No Yes
> A value Yes No Yes
< A value Yes No Yes
BETWEEN Two values Yes No Yes
IN Multi-value
Constraint List
Yes
*
No Yes
IS NULL None No No No
IS NOT NULL None No No No
* Excludes entire list.