Page 1 of 1

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

PostPosted: Sun Aug 26, 2012 2:49 pm
by 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:
Image

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.

Re: Quick filter from selected cell, clipboard or prompt

PostPosted: Sun Aug 26, 2012 2:58 pm
by 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!

Re: Quick filter from selected cell, clipboard or prompt

PostPosted: Sun Sep 16, 2012 8:56 am
by Serge
This feature (in a quite simple form) added in 1.6.3.

Re: [DONE] Quick filter from selected cell, clipboard or pro

PostPosted: Wed Oct 03, 2012 12:54 am
by wsc0918
Thanks Serge! This is really great function, I like it too much :D