[DONE] Quick filter from selected cell, clipboard or prompt

[lorenzo-s]

Hi everyone. I was searching for an HeidiSQL alternative for a long time, mostly because on Linux it is not so much usable. Can't tell why I've found this only now, but congratulation, this is a very complete and well done project. Many Linux alternatives lacks in many useful features (code completion is SQL editor, tree view, query log, simple table structure editing), and quite all of them have an ugly GUI (which here is great!)!

The only thing I really miss from HeidiSQL is the quick filter creation, which I use a lot. When you right click on any data-view cell a "Quick filter" sub-menu item is available, that allows you to apply a filter based on that selection (using value from selection, clipboard or prompt). DBeaver already has a great filter feature, so basically this will be a shorthand for filter definition!

Here is a screenshot taken right clicking a cell containing value "9" from column named "category", with text "123" present in my system clipboard:


As you can see, I have lot of options to instantly create a filter. First group creates different filters from selected value, third group prompt me for value and third group take it from clipboard.

[Serge]

We have similar feature (DBVisualizer like) planned to implement in neares version (viewtopic.php?f=3&t=583), but it supposed to work only on client side.
I agree that quick filter in HeidiSQL could be very convinient. Probably we'll include this feature in next version (it doesn't look like a complex task).

Thanks!

[Serge]

This feature (in a quite simple form) added in 1.6.3.

[wsc0918]

Thanks Serge! This is really great function, I like it too much