Icon View Incident Report

Serious Serious
Reported By: Simon Beesley
Reported On: 7/14/1999
For: Version 1.15 Build 1
# 460 Optimized Filters On NULL Values Not Working Properly

I've found that filters for null values only work if there is no index on the field; e.g.:

Cost = NULL

successfully finds null values when there is no index on Cost, but when Cost is indexed the filter finds no matching records. It does, however, find non-null values, so


works, as does NOT (Cost <> Null).

Resolution Resolution
Fixed Problem on 7/16/1999 in version 1.16 build 1