verstion 1.5.1: sort retention - how to permanently disable it??
665147Oct 14 2008 — edited Jan 12 2009Hi All-
We're using SQL Developer version 1.5.1, and are noticing that when we sort data on a table, the sort is being retained for all subsequent times we access this table. We'd like to disable this.
Problem description:
Here's the version we're using: Version 1.5.1 Build MAIN-5440
I make a database connection, Navigate to a schema, then to tables, click on a table (ex: ACCOUNT), and then click on the Data tab to see all the data. Then I click on SORT, and select ACCOUNT_ID and ascending.
The table will then sort by ACCOUNT_ID in ascending order. If I close the db connection, connect as the same schema (or any other schema that has the account table), navigate to a schema, then to tables, click on the ACCOUNT table and then the Data tab...the data is still being ordered by ACCOUNT_ID in ascending order.
The sort order is being saved.
So far, the only way I've been able to find to clear the sort retention is to do the following: Click on Tools --> Preferences --> Database --> Objectviewer Parameters. In the Data Editor section, click the Clear button.
That works...but it's a lot of steps to take every time a sort is completed.
Is there some setting in SQL Developer that can permanently be set to not save the sort choices??
thanks
-Diana