search

ox-it / ords

Automatically exported from code.google.com/p/ords
0 stars 0 forks source link

Filtering Integers does not recognize null values #660

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Go to a table with an integer field and some records where that integer 
field has null values
2. Filter on the integer field for [integer field] IS []
3. See that the filter results contain no records at all, rather than only such 
records where the value is null

What is the expected output? What do you see instead?
Fields where the value of the filed is null should be returned in the filtered 
results

Please use labels and text to provide additional information.
Chrome dev 1.0.12 - 4318.

Original issue reported on code.google.com by jajwil...@gmail.com on 11 May 2015 at 10:09

GoogleCodeExporter commented 9 years ago 
The problem is that "something = NULL" doesn't actually do anything in SQL. You 
have to do "something IS NULL". I'll add "is NULL" as a zero-argument operator 
in the filter builder.

Original comment by scott.br...@gmail.com on 14 May 2015 at 2:03

GoogleCodeExporter commented 9 years ago 
OK, I've added "is NULL" as an option for both Integer and String fields.

Original comment by scott.br...@gmail.com on 14 May 2015 at 2:15