Toad World® Forums

Another Enhancement thought...


#1

I was just making some changes in the “Configure LHS Object Types” of the Schema
Browser. I was thinking how nice it would be to be able to set a default filter
(ie. All schemas but SYS) for each of those objects.

For instance, tables I want only the tables of the current instance, but for
Jobs and Scheduler Jobs (among others) I would want all the users.

Then when we clear the filter, it would go to the chosen default rather than a
blank filter.

Just a thought…


David
UtahToad at gmail dot com
Denis Waitley:
Goals are your personal statements of what you are truly willing to do to achieve what you really want to achieve.


#2

An easy workaround would be to create a filter with your desired defaults. Then
go into the filter dialog and save it. In the future, instead of clearing your
filter, you can just reload the saved filter.


#3

I’m not sure, but doesn’t this already exist? In the SB LHS, if you click on the Filter Schema Browser button, under Name Filter->Schema Name you can select “All except SYS” so that all objects of that type for all users are displayed.

I use this all the time to achieve exactly what (I think) you are proposing.

Richard


#4

Not so much that it exists or doesn’t exist. You can create named filters, etc.
You can go into each individual Filter Screen and set it.

I was thinking (notice the Subject :slight_smile: that in your configuring of LHS, there was
some real estate that could be put to good use.


David
UtahToad at gmail dot com
Growing old is no more than a bad habit which a busy man has no time to form.
– Andre Maurois

Richard Squires wrote:

Message from: R Squires

I’m not sure, but doesn’t this already exist? In the SB LHS, if you click on
the Filter Schema Browser button, under Name Filter->Schema Name you can
select “All except SYS” so that all objects of that type for all users are
displayed.

I use this all the time to achieve exactly what (I think) you are proposing.

Richard


Historical Messages

Author: Richard Squires
Date: Wed Feb 03 20:21:55 PST 2010
I’m not sure, but doesn’t this already exist? In the SB LHS, if you click on
the Filter Schema Browser button, under Name Filter->Schema Name you can
select “All except SYS” so that all objects of that type for all users are
displayed.

I use this all the time to achieve exactly what (I think) you are proposing.

Richard

__

Author: John Dorlon
Date: Wed Feb 03 14:01:27 PST 2010
An easy workaround would be to create a filter with your desired defaults.
Then go into the filter dialog and save it. In the future, instead of
clearing your filter, you can just reload the saved filter.
__

Author: David A. Hicken
Date: Wed Feb 03 13:47:59 PST 2010
I was just making some changes in the "Configure LHS Object Types" of the
Schema Browser. I was thinking how nice it would be to be able to set a
default filter (ie. All schemas but SYS) for each of those objects. For
instance, tables I want only the tables of the current instance, but for
Jobs and Scheduler Jobs (among others) I would want all the users. Then when
we clear the filter, it would go to the chosen default rather than a blank
filter. Just a thought... -- -- David UtahToad at gmail dot com Denis
Waitley: Goals are your personal statements of what you are truly willing to
do to achieve what you really want to achieve.
__
____________ _________ _________ _________