'Table Tools' filtering
| User, date | Message |
|---|---|
|
Written by djdjohnson
1 year ago Category: Feature discussion 59 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
1 year ago 3966 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
1 year ago 59 posts since Mon, 28 Jun 10 |
The UI is easy... http://www.maxoutput.com/tablefilter.png |
|
Written by ansgar
1 year ago 3966 posts since Fri, 07 Apr 06 |
Your proposal does not take care of the tree with other databases, does it? |
|
Written by djdjohnson
1 year ago 59 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
1 year ago 3966 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
1 year ago 59 posts since Mon, 28 Jun 10 |
If nothing is selected it would apply to all visible nodes. |
|
Written by ansgar
1 year ago 3966 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
1 year ago 59 posts since Mon, 28 Jun 10 |
That works too. |
|
Written by ansgar
1 year ago 3966 posts since Fri, 07 Apr 06 |
Done in r4038. |
|
Written by djdjohnson
1 year ago 59 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. |
