How would I search for all records that have a null value in any given field? ie show me all records where abc field is null / empty / has no data in it?
Go to Solution.
I have only tested in 8.3 but I imagine 8.01 would be similar.
I assumed that when you said 'field' you meant 'Additional Field'. If so the answer depends on the field type. For a numeric you would do > 0, e.g. AlchololLevel > 0
For a string field use an empty string. e.g. MyField:""
Additional fields can also be locations so to find null values I use
i find this works well for trim property searches as well.