Table Filters Trick: Recalling the Filter

thatjeffsmith SQL Developer 4 Comments

Tell Others About This Story:

Someone asked about persisting table filters.

Quick answer, we don’t. When you leave and come back to table, the filters are no longer active.

Don’t know what I mean by filters?

A ‘split’ table into 4 regions – each with it’s own filtered view of the data.

So, if you close the table and come back, the filter won’t be there anymore.

MOSTLY.

It is there, you just have to ask for it.

Ctrl+Space.

Now scroll down. Down further. Past the column list.

There ya go…

Tell Others About This Story:

Comments 4

  1. “So, if you close the table and come back, the filter wonโ€™t be there anymore.”
    This would be less of a problem if it wouldn’t retain the sort. You ever reopened a big table or complex view where the filter is lost but not the sort?
    I still hope that my feature request will be implemented before I retire ๐Ÿ™‚
    “Filter View before opening data tab” -> https://apex.oracle.com/pls/apex/f?p=43135:7:::NO:RP,7:P7_ID:16241

    1. thatjeffsmith Post
      Author
      1. Wouldn’t this “solution” make the data tab obsolete ๐Ÿ™‚
        Most things can be done in the result grid but some things don’t work
        – Recalling a filter, I would have to search the SQL history
        – Exporting data as INSERT requires more typing because I have to replace the default table name
        – Deleting/Inserting/Updating rows

        1. thatjeffsmith Post
          Author

Leave a Reply

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