Today’s post is brought to you by a new request to the Exchange this week. They wanted to be able to quickly filter a list of objects without having to open a dialog to do it.

For a dynamic browsing of databases with a lot of objects it would be nice to have a textbox where you can filter the current object by name (may be in memory) without using a dialog

The filter dialog is powerful, but does require more than a couple of clicks…

This filter mechanism is also available on the standard tree navigator.
This filter mechanism is also available on the standard tree navigator.

Instead, they want to immediately type in their filter.

Just Look Down

No need to wildcard, just type the text you want to filter on.
No need to wildcard, just type the text you want to filter on.

Or if you want to get picky…

A little more control...
A little more control…

There’s Another Difference Here

We’re not re-querying the database once you apply the filter. This is doing client-side filtering – so it should be pretty fast.

But Wait, What is the ‘Schema Browser?’

I’m so glad you asked that question.

Here’s your homework.

thatjeffsmith
Author

I'm a Master Product Manager at Oracle for Oracle SQL Developer. My mission is to help you and your company be more efficient with our database tools.

9 Comments

  1. Nice, but if we could get the same insta-filter at the bottom of regular connection tree, it would be even better

    • thatjeffsmith

      Yeah, same thought here. But the tree has it’s own issues – say you have 6 nodes opened and expanded – does each get its own quick filter space? One big one for everything?

    • I’d say big one for everything and retain the tree structure when filtering, it makes enough sense IMO. E.g. if I have only Tables and Functions expanded in My_Connection, and filter for “Starts with PUMP”, show something like that:

      – My_Connection
      — Tables
      — PUMP_TABLE_1
      — PUMP_TABLE_TMP
      -+ Views
      -+ Procedures
      — Functions
      — PUMPER_FUNC
      + My_Connection2

      And filter the node user opens (if filter persists when you navigate the tree, that is). E.g. when I open Views:

      – My_Connection
      — Tables
      — PUMP_TABLE_1
      — PUMP_TABLE_TMP
      — Views
      — PUMP_VIEW
      -+ Procedures
      — Functions
      — PUMPER_FUNC
      + My_Connection2

    • thatjeffsmith

      Sounds whiz-bang to me…I’ll float it to the team when we start talking new features/projects for version 4.Next

    • Awesome!

      P. S. Could we somehow get a “preview comment” button, pretty please? I feel uneasy typing something complex in the comment without a chance to see how it would look. It’s like compiling the code on the first try, that never happens! Like that “tree” above, which was supposed to have 1, 2 and 3 ‘-‘s in the nodes depending on the node level, not a shorter dash and longer dash…

    • thatjeffsmith

      I’m using default WordPress comments, if you see a plugin that will do this, let me know.

    • Unable to reply to that branch anymore. Also, I left the reply regarding comment plugins yesterday, but going to guess it was blocked because of hyperlinks, so I’ll just leave the plugin names here – it should be easy to find them on official wordpress plugin directory.

      Anyway, I didn’t really work with wordpress, but there’re at least two plugins with different approaches to comment preview – one is “Ajax comment preview” and other is “Live comment preview”.

Write A Comment