Filtering tables

Toad for Oracle & DevOps Toolkit
1

Hello,

I would like define an unique filter to hide tables that start with SNP and QTX in my schema browser.
I can easily create two filters for this purpose using the filter creation dialog and specifying [Table Name -> Does Not Include] but how can I specify two criteria within the same filter?

Thank you,
M.R.

2

There’s no way to do that in the current version, however in the next beta
if you add an exclamation point before your filter, it will mean
‘not’.

So, now you can use ‘SNP*;QTX*’ to get everything that starts with
SNP or QTX.

In the next beta you can use ‘!SNP*;*QTX’ to get everything that
does not start with SNP or QTX.

3

Oops – my reply below refers to the ‘quick filter’ (the edit
box right above the list of tables, assuming you are not using the treeview
schema browser).

There’s no way to put multiple things in the ‘big’ filter (the
one you are talking about). If I can get it to work with semicolons to indicate
multiple items I’ll let you know. I don’t think I’ll be able
to squeeze that in for the next beta, though.
image004.gif

4

Oops – my reply below refers to the ‘quick filter’ (the edit
box right above the list of tables, assuming you are not using the treeview
schema browser).

There’s no way to put multiple things in the ‘big’ filter (the
one you are talking about). If I can get it to work with semicolons to indicate
multiple items I’ll let you know. I don’t think I’ll be able
to squeeze that in for the next beta, though.
image001.gif (43 Bytes)

5

Good Morning;

I’m on Toad 10.6.1.3

One way to accomplish what you asked for (in at least the version I’ve
got) is to:

6

OK, in Thursday’s beta, you’ll be able to use semicolons to indicate
multiple lists in the main SB Filter.

So you could use ‘Does Not Include’ with ‘SNP;QTX’ to
exclude all tables that have either SNP or QTX anywhere in the table name. You
can have as many semicolons as you like.

7

Reposted, I ensured Plain Text format this time.

Good Morning;

I’m on Toad 10.6.1.3

One way to accomplish what you asked for (in at least the version I’ve got) is to:

  1. Select the filter icon
  2. At the top, above the Tables tab, there is a check box called “View/Edit Query Before Executing”
  3. Select the check box, then select OK
  4. A popup window with the query will show up, add “and t.table_name not like ‘SNP%’ and t.table_name not like ‘QTX’”
  5. Confirm the expected results in your table listing
  6. Select the filter icon again
  7. Click the button at the top called “Saved Filters” and save your current filter so you can re-load it whenever you want

Roger S

This communication, including any attached documentation, is intended only for the person or entity to which it is addressed, and may contain confidential, personal and/or privileged information. Any unauthorized disclosure, copying, or taking action on the contents is strictly prohibited. If you have received this message in error, please contact us immediately so we may correct our records. Please then delete or destroy the original transmission and any subsequent reply.

8

Thanks jdorlon!

Regards,
M. R.

9

Sorry Simoneau, Roger, I cannot see your answer… please repost if you have a solution.

Regards,
M. R.

10

It worked!!!
Thank you very much Roger for sharing this tip!

Regards,
M. Rusu

11

Thank you very much Roger for sharing this tip!

You’re Welcome!

Roger S.