Repository navigation
Filter by NULL #588
Description
Not sure if there is already a method to do this but if not, then a feature request, to be able to filter records in the browser by NULL so one can see all records that have null in the respective column(s). Currently, I haven't figured out how to filter records that have no value, other than using a direct SQL statement.
Thanks
Activity
justinclift commentedon May 12, 2016
Good point, that would be useful. 😄
Support filtering for NULL values
MKleusberg commentedon Feb 2, 2017
I agree, good idea 😃 That's why I've finally implemented it 😉 If you're still around, @tonypdmtr, are you interested in testing tomorrow's nightly build to see if it's working for you?
tonypdmtr commentedon Feb 2, 2017
I sure am.
MKleusberg commentedon Feb 2, 2017
Awesome :D By the way, I totally forgot to mention: you have to search for
=NULL(all capital letters) for this.chrisjlocke commentedon Feb 3, 2017
Is this in the current nightly? Doesn't seem to work for me...
MKleusberg commentedon Feb 3, 2017
It definitely should be in there. I've also just tried this again and for me it's working. Very weird. Are you sure you're using the latest nightly build?
chrisjlocke commentedon Feb 3, 2017
Sorry, I apologise. Downloaded the last nightly, but the last nightly was yesterday's... there doesn't seem to be a nightly for this morning. Didn't look that closely at the date...
tonypdmtr commentedon Feb 3, 2017
I tried just now with the latest available download, and it does not work.
chrisjlocke commentedon Feb 4, 2017
Unfortunately, as per my message above, the nighties are temporarily unavailable. They be broke. Hopefully normal service will be resumed shortly.
justinclift commentedon Feb 4, 2017
Sorry for the problem with the nightlies over the last 2 days. They get built on a box here at my house... and the internet gateway died. Seems like a hardware problem.
Things should be ok again from tomorrow, as the gateway is being replaced presently. (typing this message through it, but needs more testing)
tonypdmtr commentedon Feb 5, 2017
Seems to work OK now (both the download and the =NULL).
MKleusberg commentedon Feb 5, 2017
Thanks for testing! 😃 Closing this issue then. If you should stumble upon any problem with this, feel free to re-open it anytime.
renschler commentedon Sep 9, 2017
how about <>NULL? It doesn't seem to be working for me.