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

'Table Tools' filtering

User, date Message
Written by djdjohnson
2 years ago
Category: Feature discussion
60 posts since Mon, 28 Jun 10
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!
Written by ansgar
2 years ago
4936 posts since Fri, 07 Apr 06
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.
Written by djdjohnson
2 years ago
60 posts since Mon, 28 Jun 10
The UI is easy...

http://www.maxoutput.com/tablefilter.png
Written by ansgar
2 years ago
4936 posts since Fri, 07 Apr 06
Your proposal does not take care of the tree with other databases, does it?
Written by djdjohnson
2 years ago
60 posts since Mon, 28 Jun 10
The easy way to handle that is to only have the filter apply to whatever level is currently selected.
Written by ansgar
2 years ago
4936 posts since Fri, 07 Apr 06
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.
Written by djdjohnson
2 years ago
60 posts since Mon, 28 Jun 10
If nothing is selected it would apply to all visible nodes.
Written by ansgar
2 years ago
4936 posts since Fri, 07 Apr 06
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?
Written by djdjohnson
2 years ago
60 posts since Mon, 28 Jun 10
That works too.
Written by ansgar
2 years ago
4936 posts since Fri, 07 Apr 06
Done in r4038.
Written by djdjohnson
2 years ago
60 posts since Mon, 28 Jun 10
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.