Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Data / Row Filtering

D.W.'s profile image D.W. posted 9 years ago in Feature discussion Permalink
After a long time away from Windows, I’m migrating back from Mac OS X. Heidi is the best balance between a feature-rich and usable MySQL client that I have found thus far for Windows, and I’ve tried a few clients. So kudos for that.

However, I find that the filtering of data in Heidi could be better. Currently, the only options I can see are either a) entering the sql code manually (slow) or using the multi-field filter (not what I’m looking to do).

On OS X I used a program called “Sequel Pro”, which I found to have good data filtering functionality. The program had a filter section at the top with a drop-down list of the fields, a drop-down of the match types (equals, does not equal, contains, does not contain, etc.) and a text field for entry of the search text. Is there a way to do this in such a manner in Heidi?

One thing that bothered me about Sequel Pro was that it was only possible to filter based on a single field (without manually inputing sql code). This could have been easily solved by having a + button to add an extra criteria… just an idea in case you choose to pursue something like this.

Thanks again.
Darrin Ward
www.DarrinWard.com
ansgar's profile image ansgar posted 9 years ago Permalink
Is it this one? http://code.google.com/p/sequel-pro/wiki/Screenshots

That logic is quite comparable to what is called "Quick filter" in HeidiSQL. Please look at the context menu of the datagrid. There are various different predefined quick filters based on the focused gridcell, plus some which allows entering a value (see the 3 dots in the menu items), plus some which simply put in your clipboard content into a WHERE clause.

Apart from that, there is still no way to enter custom SQL for the WHERE clause - that is still done via Query tab. I find that this is a good generic solution as the data tab is more the GUI related version of a query tab.
D.W.'s profile image D.W. posted 9 years ago Permalink
Yes... right screenshot of Sequel Pro and thank you for your feedback. It took me about 20 minutes to figure out that "context menu" meant to right click (part of my transition back to Windows). But yes, this helps a lot.

I still think that a filtering line similar to Sequel Pro up the top would help. The multi column filter is very presumptuous. For example, I have a DB table with many fields and over 2 million rows. Searching for almost anything in the multi column filter would return rows outside of my desired scope.

But apart from that (and this is even a step beyond Sequel Pro)... how would I filter based on multiple field searches? e.g. SELECT * FROM table WHERE field1='a' AND field2='b', but without having to manually enter that SQL in the Query tab?

Thanks again.
Darrin Ward
www.darrinward.com
ansgar's profile image ansgar posted 9 years ago Permalink
I told rubbish above:

Apart from that, there is still no way to enter custom SQL for the WHERE clause


This is surely not true - the filter allows pure SQL code. It's the ORDER BY clause which is not customizable with SQL code.

how would I filter based on multiple field searches? e.g. SELECT * FROM table WHERE field1='a' AND field2='b', but without having to manually enter that SQL in the Query tab?


Not possible currently - multiple column filters have to be entered in the filter box. Of course you can set the first filter via "Quick filter" menu and then add a second one via SQL code so that's a bit more comfortable. But this is how filter work in HeidiSQL.

Further ideas should be discussed in issue #1085.

Please login to leave a reply, or register at first.