# Improved schema browser filter **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [October 24, 2022, 2:39pm UTC](https://forums.toadworld.com/t/improved-schema-browser-filter/56323 "2022-10-24T14:39:55Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![esko.lakso](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/esko.lakso/32/13094_2.png) [@esko.lakso](https://forums.toadworld.com/u/esko.lakso)\ **Post date:** [October 24, 2022, 2:39pm UTC](https://forums.toadworld.com/t/improved-schema-browser-filter/56323/1 "2022-10-24T14:39:56Z")
In the schema browser filter all filter options except IN and NOT IN automatically add the '' characters for varchar2 fields, would it be possible to do that also for IN and NOT IN? would it also be possible to make Ctrl+u for uppercase and Ctrl+l for lower case work in this filter dialog, same as in editor? ![image](https://global.discourse-cdn.com/quest/original/2X/3/30fe1977c9ab0e4a014ffcf2b3b5e115c6c8241f.png) ---
**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:** [October 24, 2022, 5:36pm UTC](https://forums.toadworld.com/t/improved-schema-browser-filter/56323/2 "2022-10-24T17:36:23Z")
Hi Esko, That seems reasonable. I don't remember if there was a reason that we didn't include this with in/ not in. I think we can add the upper/lowercase shortcut there too. I logged it internally so I don't forget about it. -John ---
**Author:** ![esko.lakso](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/esko.lakso/32/13094_2.png) [@esko.lakso](https://forums.toadworld.com/u/esko.lakso)\ **Post date:** [October 24, 2022, 5:46pm UTC](https://forums.toadworld.com/t/improved-schema-browser-filter/56323/3 "2022-10-24T17:46:54Z")
If I type A,B,C using in or not in operator for a varchar field it would be great if they are added as IN ('A','B','C') when I click add to filter button ---
**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:** [October 27, 2022, 4:29pm UTC](https://forums.toadworld.com/t/improved-schema-browser-filter/56323/4 "2022-10-27T16:29:24Z")
Hi Esko, I'm not sure if you're aware of this, but if you use this button to find the values to filter by, they are automatically quoted. I realize that this technique might not be practical if you have lots of possible values. Just FYI. I'll still add your request. ![image](https://global.discourse-cdn.com/quest/original/2X/e/ecd787ea431e9b517667990bab6723c4b9ac3356.png) ---
**Author:** ![esko.lakso](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/esko.lakso/32/13094_2.png) [@esko.lakso](https://forums.toadworld.com/u/esko.lakso)\ **Post date:** [October 27, 2022, 7:09pm UTC](https://forums.toadworld.com/t/improved-schema-browser-filter/56323/5 "2022-10-27T19:09:08Z")
I had never paid attention to those three dots and see the usefullness for sure. In a table with a few miljon rows it does not allow picking the right criteria easily, it however does allow me to pick the number of items I need and then update the filter in the textbox. I still think that the improvements I suggested should be made when time permits. It is fantastic, I have been using Toad since perhaps 2003 and still learn new things all the time. I must say that Quest and the team working with Toad has improved a lot these last few years and I am really impressed and thankful for all you guys do. John! You are a rockstar. ---
**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:** [October 27, 2022, 7:11pm UTC](https://forums.toadworld.com/t/improved-schema-browser-filter/56323/6 "2022-10-27T19:11:30Z")
Thanks Esko, I appreciate that. These changes will be in Monday's beta. ---
**Author:** ![Abraham\_Olsen](https://avatars.discourse-cdn.com/v4/letter/a/57b2e6/32.png) [@Abraham\_Olsen](https://forums.toadworld.com/u/Abraham_Olsen)\ **Post date:** [October 31, 2022, 7:18am UTC](https://forums.toadworld.com/t/improved-schema-browser-filter/56323/7 "2022-10-31T07:18:55Z")
> [@JohnDorlon](#): > > I think we can add the upper/lowercase shortcut there too Indeed you are a rockstar. It will be very nice if the upper/lowercase shortcut would work in other dialogues such as "find", "variables" (when running a select with bind variables, pasting a value for a variable and it needs to be in a certain case), etc... ---
**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:** [October 31, 2022, 12:13pm UTC](https://forums.toadworld.com/t/improved-schema-browser-filter/56323/8 "2022-10-31T12:13:14Z")
Thanks Abraham. I made the change such that upper/lower case should work in any edit control, regardless of which window it's in. BTW, today's beta will likely be delayed, but this change should be in the _next_ beta, whenever that is. -John ---
**Author:** ![esko.lakso](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/esko.lakso/32/13094_2.png) [@esko.lakso](https://forums.toadworld.com/u/esko.lakso)\ **Post date:** [November 3, 2022, 5:42pm UTC](https://forums.toadworld.com/t/improved-schema-browser-filter/56323/9 "2022-11-03T17:42:19Z")
The changes works great, thank you. BTW, the upper/lower case improvment was there, but it is not in the release Notes