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.

Filter for display columns

tihoho's profile image tihoho posted 2 months ago in Feature discussion Permalink

Hey! It's me again :)

could you add a filter for the columns you want to display?

Like as data filter (bottom of table content).

Here

this would speed up the browsing of data in tables that have many columns. And it's faster than selecting the displayed columns at the top.

Example: I put in filter "arrive" and realtime view only columns "dtarrive" and "is_arrived".

ansgar's profile image ansgar posted 2 months ago Permalink

That's a screen of a custom query, or? Don't you think you could just modify the query to filter columns away?

tihoho's profile image tihoho posted 2 months ago Permalink

Ansgar, yep, it's custom query.

actually changing the query is not easier. often you have to work with tables with more than 50 columns. and you need to look at a specific column for a moment. and then return it as it was. it would be very convenient to find the required column through the filter, and return the full display back. this is 2 seconds * the number of hours of work with tables. savings hours per year. :)

I have not seen this feature in any GUI program for working with tables. Everyone filters only data, not columns.

It will be faster because no need to waste time on the network (while the request is sent, while it is processed, while it returns). because the filter will work with data that has already been received.

If you decide to implement this functionality, then here is my advice for which all data analysts will be grateful to you:

example:

all table columns: id, dtsent, dtarrive, dtpaid, firstname, status, sum, service_id, metrica_id

variants:

filter data: "dt" displayed columns: dtsent, dtarrive, dtpaid

filter data: "id" displayed columns: id, dtpaid, service_id

filter data: "_id dt" displayed columns: service_id, metrica_id, dtsent, dtarrive, dtpaid

ansgar's profile image ansgar posted 2 months ago Permalink

Related: there's a context menu on the column headers, offering to hide/show single columns: Description

Also related, but for data filtering: click on Edit > Filter panel, to show an input box below the grid, with regular expression support.

tihoho's profile image tihoho posted 2 months ago Permalink

I know the functionality you are talking about. in my screenshot in the first post it is.

content filter with regular expressions and gave me the idea that it would be great to have the same filter next to it only for column names.

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




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.