remove saved filters and ordering on data tab

[expired user #9402]'s profile image [expired user #9402] posted 8 years ago in General Permalink
When I choose to apply a filter or ordering on data tab for a table, every time I open the data tab, the previous filters and ordering are applied automatically. If I make a typo on the filters, or apply a filter or ordering that requires too query time, the application freezes. So if I restart the application and open the data tab to fix the filters, application freezes again before I get a chance to do so because previous filters and ordering are applied automatically.

There is a way to remove the filters through settings in the previous versions, but I couldn't find a way to do it on my version, anyone knows how can I do that?

My version is: 9.3.0.4984
ansgar's profile image ansgar posted 8 years ago Permalink
Rightclick the table in the left tree, then click "Clear data tab filter".
[expired user #9402]'s profile image [expired user #9402] posted 8 years ago Permalink
That's it, thanks.
[expired user #9333]'s profile image [expired user #9333] posted 8 years ago Permalink
I have similar problem with sorting (saved sorting on unindexed collumns makes the table effectivelly inaccessible). Is it possible to remove saved sorting in data tabs? A similar right-click option would be nice, but a preventive option to remove all saved sortings/filters at once would be even better.
-PSi-'s profile image -PSi- posted 6 years ago Permalink

Will clearing of the tick box "Remeber filters, sorting..." at Preferences also clear all the filter history? I wish to be able to see and re-apply the filters I've used before, but not have any filters automatically applied?

ansgar's profile image ansgar posted 6 years ago Permalink

Yes, it will clear the history at the end of each session! That's what "remember" means here.

You can clear an existing filter before clicking the data tab, by right click on the tree, then click "Clear data tab filter".

-PSi-'s profile image -PSi- posted 6 years ago Permalink

Yes, once for every database, but will I remember to do it every tike I open HeidiSQL? Nope :(

Have you by chance any plans of allowing us to tick a new box at Preferences to automatically clear the tab filters at session end (or session start)?

I hope you have :)

ansgar's profile image ansgar posted 6 years ago Permalink

You mean "clear the tab filters" in a way that the history is cleared? That's what the current checkbox "Remember filters, sorting..." is for (if you uncheck it). Probably you mean just the currently active filter, while keeping the history?

-PSi-'s profile image -PSi- posted 6 years ago Permalink

yes! I'm sorry that I was not clear in my response. I've used data filters to search for data from tables, and occasionally those filters are causing slow response. If I forget to press [Clear] before leaving HeidSQL, the filter will be active when I go to see the table data next time (wait, wait, wait...).

I'd wish I could select from the Preferences to have all these filters cleared but still have the filters in the drop-down menu if I deliberately wish to apply them again!

1 attachment(s):
  • HeidiSQL
ansgar's profile image ansgar posted 6 years ago Permalink

So you don't want to clear them, you just want no filter to be active. You should file an issue request on Github.

[expired user #11406]'s profile image [expired user #11406] posted 6 years ago Permalink

Hello

Pre-formatted code blocks are used for writing about programming or markup source code.


ansgar's profile image ansgar posted 6 years ago Permalink

Hm, well. Does that have anything to do with this thread here?

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