Sortable columns in table detail popup window

Provides intelligent code completion for SQL Server editors.

Moderators: Anu Deshpande, Aaron Law, David Priddle

Sortable columns in table detail popup window

Postby JohnHennesey » Mon Jul 07, 2014 1:15 pm

When hovering over a table name in the query window a context window appears by clicking on the "[schema].[table], [comments]" tooltip. The information to script or get a summary is made possible; it would be very helpful to be able to sort by column name [additionally by data type too] in the pop up window... I have used other tools in the past with this capability; once one gets used to it it comes in mighty handy (it is tedious to look through 200 columns in ordinal order, or find the one xml column in the list).

Is this something that can easily be added to the product?

Thanks in advance,
John
JohnHennesey
 
Posts: 4
Joined: Tue Nov 05, 2013 10:22 pm

Postby Aaron Law » Mon Jul 07, 2014 5:38 pm

Hi John,

I saw your request a while back on UserVoice and gave it a go but decided not to look into it too much as it was becoming complicated than I'd hoped. In theory it should be easy since the winforms DataGridView comes with the sorting functionality built in. However our popup can't take focus away from the main editor window and clicking to sort gave focus to the grid, which resulted in our popup closing.

I just gave it another go and I think I've found a simple work around, if all goes well I'll include it in a beta build this week. I'll let you know when the build is up.

Thanks,
Aaron.
Aaron Law
 
Posts: 251
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software

Postby JohnHennesey » Mon Jul 07, 2014 5:52 pm

Aaron - Thanks so much for the quick response. Thanks for giving it another shot, and good luck!

:)
John
JohnHennesey
 
Posts: 4
Joined: Tue Nov 05, 2013 10:22 pm

Postby Aaron Law » Thu Jul 10, 2014 11:16 am

Hi John,

The columns should now be sortable in 6.4.0.266, hope that helps!
Aaron Law
 
Posts: 251
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software

Thanks!

Postby JohnHennesey » Thu Jul 10, 2014 12:25 pm

Love it! Thanks! And thank you for the quick turn around!!
JohnHennesey
 
Posts: 4
Joined: Tue Nov 05, 2013 10:22 pm


Return to SQL Prompt 6

Who is online

Users browsing this forum: No registered users and 0 guests