Suggestions are no longer in alphabetical order

CJMartin

Ranked suggestions is unchecked but the suggestion list is no longer in alphabetical order.  I believe this actually started around version 10.7.  I just want my list to show in alphabetical order again, specifically the database objects list.

Dan_J

Hi @CJMartin

To follow up on my last note, our development team have confirmed that suggestions should indeed be in alphabetical order, however there appears to have been a bug introduced in v10.6.18 that is causing issues with this. They have added this to their work to do, however at this stage I'm not certain when they are going to get to this.

In the mean time, if you role back to v10.6.17 you should find your suggestions are in alphabetical order: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.6.17.21532.exe

squigley

Hello @CJMartin,

Just wanted to update you that a new version of SQL Prompt has been released.

Can you try installing the version below and let us know if it helps you out?

Download Link: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.10.3.25844.exe

Thanks!

Dan_J

Hi @CJMartin

Thanks for reaching out to us regarding this.

I have just tried to replicate this with Ranked Suggestions turned off, however my suggestions list is in alphabetical order.

Just as an initial thought, if you haven't already, please can you update to the very latest version of SQL Prompt (v.10.8.2) to see if this resolves this issue for you? This version can be downloaded directly from: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.8.2.23489.exe

If the issue does persist, would it be possible to see a screenshot of some of your suggestions, if possible?

CJMartin

Thanks for replying.  I am currently using SQL Prompt version 10.8.2.23489 with SSMS 15.0.18338.0.  Attached are photos of the suggestions and options.

 

Dan_J

Hi @CJMartin

Thanks for your response on this.

Just to advise that I am engaging with our development team on this and will come back to you as soon as I have an update for you.

Dan_J

Hi @CJMartin

My apology for the delay in updating you on this.

Just to advise that this is currently with our development. Given their current very high workload, I'm afraid at this stage that I'm not sure when they will start looking at this. I will however keep a close eye on it's progress and will update you as soon as I have more information for you on this.

CJMartin

@Dan_J, thanks for the update.

Chuck

Dan_J

Hi @CJMartin

Just to advise you that our development team are currently working on this. I hope to have a further update for you on this shortly.

Thank you for your patience with us!

Dan_J

Hi @CJMartin

My apology for the delay in updating you on this.

I am aware that a fix has been established for this issue. The next release of SQL Prompt is now not due until January, I will let you know as soon as I am aware it is available for you to download.

Thank you for your patience with us on this!

CJMartin

Dan_J said:

Hi @CJMartin

My apology for the delay in updating you on this.

I am aware that a fix has been established for this issue. The next release of SQL Prompt is now not due until January, I will let you know as soon as I am aware it is available for you to download.

Thank you for your patience with us on this!

Thank you for the update. 

Chuck

CJMartin

squigley said:

Hello @CJMartin,

Just wanted to update you that a new version of SQL Prompt has been released.

Can you try installing the version below and let us know if it helps you out?

Download Link: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.10.3.25844.exe

Thanks!

Yes, suggestions are working as expected now.  Thank you very much!

CJMartin

squigley said:

Hello @CJMartin,

Just wanted to update you that a new version of SQL Prompt has been released.

Can you try installing the version below and let us know if it helps you out?

Download Link: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.10.3.25844.exe

Thanks!

Yes, suggestions are working as expected now.  Thank you very much!

Chuck