distal-attribute
distal-attribute
distal-attribute
distal-attribute

data view and multiple presets of colums filter

User, date Message
Written by evgen_sql
1 year ago
Category: General
3 posts since Sat, 01 Dec 12
Hi

your HeidiSQL is GREAT,

but 3 things coold be better:

1. when you click on row in table- it could open in new window in vertical view (it could be option in context menu) not in horizontal - too hard to horizontal scroll to find right colums
2. the same reason - it will be good if user could be made a multiple presets of colums filter for each table

3. when using ssh tunel - too often connection close, 10 sec max - i dont want to disconnet/reconnet every time - it is too slow to work



Thank You for HeidiSQL!

p.s.
sorry for my english.
Written by ansgar
1 year ago
4801 posts since Fri, 07 Apr 06
1. I think there is an issue report somewhere, can't recall it right now.

2. Column filters are remembered in a session, and if you want you can tell HeidiSQL to remember these across sessions (Tools > Preferences > Data > "Remember filters...")

3. Do you run the latest build? If not please update. I introduced a keep-alive-ping recently, which pings each 20s.
Written by evgen_sql
1 year ago
3 posts since Sat, 01 Dec 12
3. using heidisql.r4233.exe

2. i see that filters are remembered. But there is only 1 colums filter per session.

I use tables whith 320 colums. I searching for the colum that i need (in "data" tab) for 5 min. If i could open this row in verical view or to set MULTIPLE colums filter presets it will be much faster
Written by ansgar
1 year ago
4801 posts since Fri, 07 Apr 06
2. what do you mean with "there is only 1 columns filter per session"?

If I am adding a second and third filter on the data tab, and have the above mentioned preference activated, HeidiSQL remembers all filters, and restores them when connecting to the same server the next time. Is that not the case on your side? Please describe more *exact*.

3. r4233 is ok, but you could update anyway.
Written by evgen_sql
1 year ago
3 posts since Sat, 01 Dec 12
may be i dont know all features of HeidiSQL, but i mean this:



only 1 possible preset
Written by ansgar
1 year ago
4801 posts since Fri, 07 Apr 06
That's not a filter, man, that's the column selection. Yes, there is no way to remember different column selections on each start. But that would be the wrong way in your case. If you have a special table with such a huge number of columns, that's not a normal case you can work on with the normal way in HeidiSQL - the data tab. You should definitely work with a query tab and SQL snippets. That way, you can also have multiple presets opened in multiple query tabs, and you just need to click the tabs in order to switch to a different one. The data tab is not suitable in such situations.
Written by jfalchMoney, Euro
1 year ago
354 posts since Sat, 17 Oct 09
instead of column filters in the client, why do you not create appropriate VIEWs in the database, containing the column groups that you usually use ? Under certain conditions, views are even updateable.
 

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