'Table Tools' filtering

[expired user #5015]'s profile image [expired user #5015] posted 12 years ago in Feature discussion Permalink
I'd love to see a feature in the Table Tools screen that allows tables to be selected/deselected based on different criteria...

* Table type (Table/View/Function/Merge Table, etc.)
* Table engine (MyISAM, InnoDB, etc.)
* Table collation
* Wildcard search of table name

This way it would be easy to deselect Views from a maintenance operation, for example.

Just a thought. It seems like it would be nice to have.

Thanks for a great product!
ansgar's profile image ansgar posted 12 years ago Permalink
The tree can not be easily filtered, I'm also not having an idea of how that could work GUI wise. But tree nodes are preselected when you select wanted items in the main windows, in the database tab.
[expired user #5015]'s profile image [expired user #5015] posted 12 years ago Permalink
The UI is easy...

http://www.maxoutput.com/tablefilter.png
ansgar's profile image ansgar posted 12 years ago Permalink
Your proposal does not take care of the tree with other databases, does it?
[expired user #5015]'s profile image [expired user #5015] posted 12 years ago Permalink
The easy way to handle that is to only have the filter apply to whatever level is currently selected.
ansgar's profile image ansgar posted 12 years ago Permalink
There is "currently selected" level most of the time. There may be nodes from only one level selected but that's a different thing. As long as you did not click into the tree there is no selected level.
[expired user #5015]'s profile image [expired user #5015] posted 12 years ago Permalink
If nothing is selected it would apply to all visible nodes.
ansgar's profile image ansgar posted 12 years ago Permalink
Hm. What about a right click menu in the tree, which offers selecting objects of the same type (table, view, ...) based on the clicked node?
[expired user #5015]'s profile image [expired user #5015] posted 12 years ago Permalink
That works too.
Code modification/commit from ansgar.becker, 12 years ago, revision 6.0.0.4038
Add context menu to object tree in export dialog, and add items to check all/none/bytype. See http://www.heidisql.com/forum.php?t=9844
ansgar's profile image ansgar posted 12 years ago Permalink
Done in r4038.
[expired user #5015]'s profile image [expired user #5015] posted 12 years ago Permalink
Thanks for doing that.

There is one thing missing though... I'd love to see an "Uncheck" option that works the same as the new "Check" option. So we can leave everything but tables, or views, or functions checked.

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