Feature request: Add an option to filter empty records through the filter GUI (Browse data)

[SilvioGrosso]

Hello everyone,

Please, add an option to Filter empty records through the "Browse data" GUI.

Currently, on Windows 10 - Windows 7 (64bit .exe installer) I can easily filter all empty cells in my tables by writing some simple SQL code.
E.g.
SELECT * FROM mytable WHERE columnA = ' '

On the contrary, it looks like this option is not implemented yet as filter through the GUI.
On the "browse data" grid GUI I am able to select NULL and NOT NULL values whereas I am unable to filter empty records in my Sqlite database.
I have read the Wiki short "manual" but this option is not listed in the filter section.

I am testing the 3.10.99 version (on Windows 7 - 10)
QT 5.7.1
Sqltie 3.20.0

Thanks a lot !

[karim]

Sounds like a useful addition to DB4S filter. 😄

Do you have any suggestion about which operator we should use? Something like ='' maybe?

In the meantime, you can try sorting the column (by clicking on its name) and it should show you all the empty fields together. Not ideal I know but it works. :)

[SilvioGrosso]

Hello !

Do you have any suggestion about which operator we should use? Something like ='' maybe?

Perhaps:=' ' --to select *empty* records together with the option: <>' '--the other way around (select all records which are *not empty*)

In the meantime, you can try sorting the column (by clicking on its name) and it should show you all the empty fields together. Not ideal I know but it works. :)

Yep. It works fine :-)

[MKleusberg]

Just added the two filters as suggested by @SilvioGrosso. I hope I didn't break anything else during the process because the filter code is already quite complex 😉 A quick warning: "<>''" also leaves out all records with a NULL field because SQLite implicitly converts them to empty strings when doing string comparisons. I don't think it's a big problem and there's not much we can do about it without making this overly complicated.

@SilvioGrosso Can you check if it's working for you as expected with tomorrow's nightly build? 😄

And anybody interested in updating the Wiki article?

[SilvioGrosso]

Hello everyone !
You made my day :-)

Just tested on Windows 10 (64 bit) with today's daily build.
Everything is filtered as expected.

I have uploaded a video on YouTube to show this new feature (I hope you don't mind):
https://www.youtube.com/watch?v=UtP0Qg0wNpw

Many thanks indeed !

[MKleusberg]

Awesome, I'm glad I could help 😄 Thanks a lot for testing!