Can you add filtering to the following areas to aid usability, please?
Customize Toolbars | Commands
In this case it would be good to have a filter edit box, and only show categories and commands containing that text. It's tedious trying to find the toolbar button and what category it is under.
Schema Browser | Roles | Object Grants
I feel this section is desperate for a filter. If I want to check if a role has certain grants using the UI it's reaallyyy tedious. (Yes, I know I could write a query on the data dictionary, but UIs are there to make our life easier).
As a very minor cosmetic side point, I've noticed that in the latest version of Toad (25.2.376.6086) grid foreign key lookup button has lost its ellipsis, it's a blank button now. The ellipsis used to give a clue it would take you to another screen.
Customize toolbars: We can add that, but in the meantime, the easiest thing to do is: Don't find the category. Just go to down to [All], then you can type to search in the "commands" box.
Schema Browser: Agreed. I'll try to come up with something.
Ellipsis button: Yup, I see what you mean. Will fix.
Upvoting the SB filter request. It is something I have long wanted. I have always resorted to queries of the data dictionary, but having a filter in these grids gives quick access to the controls in the page to work on the filtered data.
Thanks very much John, for the fast turn around. The filter on Toolbar Commands looks really useful.
Regarding the filtering on SB-Users and SB-Roles, is that a single column at a time filter only? If so, could it be a multiple item filter? Some of our schemas are huge with tens of thousands of objects, and I am often wanting to filter across multiple criteria, e.g. Object Owner + Object Type + Privilege etc.
Ok, I'll have this soon. Maybe not next beta. I'm close, but it still needs some polishing, and taking a few days off this week so I may not finish it until the beta after that.
I wrote it in a very generic way so we could easily apply this to the same kind of control elsewhere in Toad.
You can see in the screenshot below, I've selected the VIEW object type. If I were to select another dropdown at this point, it would only have values from the VIEW rows. But you can always type in a value (or part of one, for example SEL instead of SELECT). I'm trying to decide if having the dropdowns is a good idea or more trouble than they are worth. Typing in part of a value is probably faster than clicking a dropdown and looking. I'm starting to think a plain old edit box will be fine.
Anyway, we should have something in the next beta or two.
I know what you mean regarding lookups versus edit boxes for filtering, there's definitely pros and cons for both.
I initially thought you would do the filtering similar to the filter on say Tables in Schema Browser, with a filter speedbutton with icon representing if filtering was on, which opens this sort of thing:
With filters for each column and how it is filtered. Some benefits I see are:
a) The filters are far more flexible, e.g. you can do "in" lists like the image
b) You can save the filter
c) Name filters section could be dynamic based on the columns, so the dialog could be fairly generic.
d) The UI isn't cluttered by combos / edit boxes
e) The user experience is more unified - as filtering via a speedbutton is common in Toad.
However, I'm only suggesting from a user point of view, so of course, disregard if you don't think it's a good idea.
