# Filtering tables **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [June 27, 2011, 10:34am UTC](https://forums.toadworld.com/t/filtering-tables/10536 "2011-06-27T10:34:37Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![mr2001](https://avatars.discourse-cdn.com/v4/letter/m/a88e4f/32.png) [@mr2001](https://forums.toadworld.com/u/mr2001)\ **Post date:** [June 27, 2011, 10:34am UTC](https://forums.toadworld.com/t/filtering-tables/10536/1 "2011-06-27T10:34:37Z")
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. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [June 27, 2011, 10:34am UTC](https://forums.toadworld.com/t/filtering-tables/10536/2 "2011-06-27T10:34:37Z")
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. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [June 27, 2011, 10:34am UTC](https://forums.toadworld.com/t/filtering-tables/10536/3 "2011-06-27T10:34:37Z")
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](https://global.discourse-cdn.com/quest/original/1X/41f8730228f3026bfff01444752384c5c40770f4.gif) ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [June 27, 2011, 10:34am UTC](https://forums.toadworld.com/t/filtering-tables/10536/4 "2011-06-27T10:34:37Z")
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](https://global.discourse-cdn.com/quest/original/1X/2daeaa8b5f19f0bc209d976c02bd6acb51b00b0a.dat) (43 Bytes) ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [June 27, 2011, 10:59am UTC](https://forums.toadworld.com/t/filtering-tables/10536/5 "2011-06-27T10:59:40Z")
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: ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [June 27, 2011, 11:39am UTC](https://forums.toadworld.com/t/filtering-tables/10536/6 "2011-06-27T11:39:54Z")
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. ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [June 27, 2011, 12:59pm UTC](https://forums.toadworld.com/t/filtering-tables/10536/7 "2011-06-27T12:59:57Z")
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. ---
**Author:** ![mr2001](https://avatars.discourse-cdn.com/v4/letter/m/a88e4f/32.png) [@mr2001](https://forums.toadworld.com/u/mr2001)\ **Post date:** [June 27, 2011, 1:02pm UTC](https://forums.toadworld.com/t/filtering-tables/10536/8 "2011-06-27T13:02:52Z")
Thanks jdorlon! Regards, M. R. ---
**Author:** ![mr2001](https://avatars.discourse-cdn.com/v4/letter/m/a88e4f/32.png) [@mr2001](https://forums.toadworld.com/u/mr2001)\ **Post date:** [June 27, 2011, 1:08pm UTC](https://forums.toadworld.com/t/filtering-tables/10536/9 "2011-06-27T13:08:32Z")
Sorry _Simoneau, Roger_, I cannot see your answer… please repost if you have a solution. Regards, M. R. ---
**Author:** ![mr2001](https://avatars.discourse-cdn.com/v4/letter/m/a88e4f/32.png) [@mr2001](https://forums.toadworld.com/u/mr2001)\ **Post date:** [June 27, 2011, 1:40pm UTC](https://forums.toadworld.com/t/filtering-tables/10536/10 "2011-06-27T13:40:52Z")
It worked!!! Thank you very much Roger for sharing this tip! Regards, M. Rusu ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [June 27, 2011, 1:55pm UTC](https://forums.toadworld.com/t/filtering-tables/10536/11 "2011-06-27T13:55:47Z")
> > Thank you very much Roger for sharing this tip! You’re Welcome! Roger S.