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.

Request: Keyboard shortcuts to focus and blur filter textbox

igitur's profile image igitur posted 3 years ago in General Permalink

Hi,

I use the filter textbox a lot, because some of my DBs are huge. However, I have to use the mouse every time I need to focus the filter textbox. Could you add keyboard shortcuts to focus the filter textbox (e.g. Ctrl+E) and also to clear and blur (unfocus) it (e.g. Esc)? I think these would add a lot to productivity.

thanks Francois

igitur's profile image igitur posted 3 years ago Permalink

Let me expand a bit.

Ctrl+E: Focuses the filter textbox Esc: Clears and unfocuses the filter textbox, but only when the filter textbox already has the focus. Ctrl+Shift+E: Clears the filter textbox regardless of which control currently has the focus.

ansgar's profile image ansgar posted 3 years ago Permalink

Esc now clears the focused filter box, in r5114.

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.
igitur's profile image igitur posted 3 years ago Permalink

Thanks. Any comment on the other suggestions?

ansgar's profile image ansgar posted 3 years ago Permalink

Ctrl+E: Focuses the filter textbox

Which one - the database or the table filter box? And why "E"?

Esc: Clears and unfocuses the filter textbox, but only when the filter textbox already has the focus.

You cannot "unfocus" a control. You need to focus just another control to do that. So, which one shall then be focused? To be honest, I feel focusing another control would be quite non-intuitive, as it's mostly not the control the user wants.

Ctrl+Shift+E: Clears the filter textbox regardless of which control currently has the focus.

Makes sense, I guess then for both filter boxes. Only I find this "E" not quite the right character for removing a filter. But anyway, the user can customize the shortcuts, and Ctr+Shift+F is already in use by "Search text on server".

igitur's profile image igitur posted 3 years ago Permalink

Ctrl+E: Focuses the filter textbox

Which one - the database or the table filter box? And why "E"?

Ctrl+E is the shortcut to focus the search bar in Microsoft Outlook and Google Chrome, but the choice of shortcut is up to you. I also chose 'E' because I saw it wasn't taken already.

Esc: Clears and unfocuses the filter textbox, but only when the filter textbox already has the focus.

You cannot "unfocus" a control. You need to focus just another control to do that. So, which one shall then be focused? To be honest, I feel focusing another control would be quite non-intuitive, as it's mostly not the control the user wants.

Oh, of course. I actually knew that. I would focus the treeview on the left. It's between the treeview and search textbox that I jump all the time. If I could get rid of mouse action, it would speed it up a lot.

Ctrl+Shift+E: Clears the filter textbox regardless of which control currently has the focus.

Makes sense, I guess then for both filter boxes. Only I find this "E" not quite the right character for removing a filter. But anyway, the user can customize the shortcuts, and Ctr+Shift+F is already in use by "Search text on server".

ansgar's profile image ansgar posted 3 years ago Permalink

So, in my just committed r5115 we have several new hotkeys:

  • Ctrl+E: table filter
  • Ctrl+D: database tree
  • Ctrl+1: first visible main tab
  • Ctrl+2: second visible main tab
  • Ctrl+3: third visible main tab
  • Ctrl+4: fourth visible main tab
  • Ctrl+5: fifth visible main tab

Also, in the main toolbar, you will find a new "Go to" menu, with all these hotkeys.

All hotkeys are customizable per Tools > Preferences > Shortcuts > Various.

igitur's profile image igitur posted 3 years ago Permalink

Working great, thanks!

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