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…
Instead, they want to immediately type in their filter.
Just Look Down
Or if you want to get picky…
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.
9 Comments
Thank you Jeff! Homework, ack!
Very nice! Another useful nugget I wasn’t aware of!
Nice, but if we could get the same insta-filter at the bottom of regular connection tree, it would be even better
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
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…
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”.