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

'Table Tools' filtering

djdjohnson posted 3 years ago in Feature discussion
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 posted 3 years ago
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.
djdjohnson posted 3 years ago
The UI is easy...

http://www.maxoutput.com/tablefilter.png
ansgar posted 3 years ago
Your proposal does not take care of the tree with other databases, does it?
djdjohnson posted 3 years ago
The easy way to handle that is to only have the filter apply to whatever level is currently selected.

ansgar posted 3 years ago
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.
djdjohnson posted 3 years ago
If nothing is selected it would apply to all visible nodes.
ansgar posted 3 years ago
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?
djdjohnson posted 3 years ago
That works too.
ansgar posted 3 years ago
Done in r4038.

djdjohnson posted 3 years ago
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.