Oracle SQL Developer 4: A Tweak With Table Filters

thatjeffsmith SQL Developer 8 Comments

Tell Others About This Story:

In previous versions of Oracle SQL Developer, if you start typing in the Data tab’s filter dialog on a Table Editor, SQL Developer would make suggestions for you.

I'm trying to type here!

I’m trying to type here!

A few folks have asked that we not be so aggressive with the ‘help’ here. And I wholeheartedly agree. So in version 4…

If You Want Help, Ask For It!

Use the keyboard to activate the 'help.'

Use the keyboard to activate the ‘help.’

So what’s the magic key sequence?

It’s the same as in the worksheet when activating the Code Insight feature.

Ctrl+Spacebar

And we fixed a persnickety bug while we were at it…when using the history list to pop a filter in, after clicking it into the form, the initial search text be appended with the filter text instead of replaced.

That’s finally fixed for our next EA build.

Yuck - this is finally fixed :)

Yuck – this is finally fixed 🙂

I Know I’m Weird

Why make such a big deal out of such a little thing? I know I drive some people nuts with my opinions. It’s my opinion that little features like this are where people LIVE in the tool. If you’re looking at data all day, let’s do our best to make that as pleasant as possible. So whilst we might break things or change things or build new things that you don’t like, please remember our goal is to always make things ‘better.’

If you think this particular change is wrong, we still have time to ‘fix’ it for version 4, so don’t be shy!

Related Posts

Tell Others About This Story:

Comments 8

    1. thatjeffsmith Post
      Author
  1. Jeff, thank you for this fix. I use Ctrl+Spacebar all the time. Love it.

    Q: is there a way to grab the sql that gets generated? I don’t see e.g. a right click for this.

    1. thatjeffsmith Post
      Author
      1. I see the statement. Thank you. However, if I choose to Show only certain columns, that query under Statements still includes all columns.

      2. thatjeffsmith Post
        Author

Leave a Reply

Your email address will not be published. Required fields are marked *