To Toad for SQL Server community
Allow for sorting ascending/descending while using the table viewer (order-by in filter window). Right now it defaults to ascending only, and you have to click on "custom sql" and put in the desc yourself. Toad for Oracle has this feature.
I agree
3 votes
Rank26
Idea#30
This idea has been completed.
Object Explorer / Schema Browser
»
Comment
Similar Ideas Show
Object Explorer / Schema Browser
»
Feedback Score
4
Rank12
4 comments
for Idea: Quick Jump To Column In Viewer Table Using Object Explorer
Just something cool or urgent
»
Feedback Score
3
Rank26
Import/Export data
»
Feedback Score
4
Rank12
Events
-
Status Changed from Active to Completed1 year ago
-
The idea was posted1 year ago
Attachments
-
mkaminski attached: toad_sort.jpg
Example of order by selection in Toad for Oracle
Comments (4)
-
Moderator CommentHi mkaminski, can you please give me more details what exactly you want to sort? Can you attach the picture illustrating your idea? Many thanks!
0 Vote up
-
In toad for SQL, in the filter dailog box, in the order-by tab, you can choose a column, but it only does ASCENDING by default, unless you go into the SQL tab and make it custom SQL, and put in the DESC manually. However, in Toad for Oracle, you can choose the sort order as you select your column. This is a big timesaver. See the attachment of a screen shot from Toad for Oracle.
0 Vote up
-
Moderator Comment
Here is the note from beta release notes:
You can now customize data filtering in the DOV (Database Object Viewer) to organize columns in ascending or descending order. Select the Filter icon in the Data tab of the DOV and navigate to the Order By page in the Filer Data pane. By default Ascending mode is on, to sort columns in descending order clear the checkbox next to selected columns.
the full RN is here: http://dev.toadforsqlserver.com/releasenotes/beta/ToadSqlServBetaRN.htm
I believe it is what you are talking about.
1 Vote up
-
Social Web