Suggestions are no longer in alphabetical order

• 
  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?

  
  
  

  Dan_J September 30, 2021 20:19

  - 0 +
• 
  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.

  
  

   

  

  CJMartin September 30, 2021 20:30

  - 0 +
• 
  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 October 05, 2021 16:12

  - 0 +
• 
  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
  

  
  
  

  Dan_J October 07, 2021 08:20

  - 0 +
• 
  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.
  

  
  

  Dan_J October 21, 2021 11:26

  - 0 +
• 
  @Dan_J, thanks for the update.
  
  Chuck

  CJMartin October 21, 2021 13:39

  - 0 +
• 
  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 December 13, 2021 10:53

  - 0 +
• 
  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!
  

  
  

  Dan_J December 23, 2021 11:30

  - 0 +
• 

  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 December 28, 2021 15:07

  - 0 +
• 
  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!
  

  
  
  

  squigley January 04, 2022 23:27

  - 0 +
• 

  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 January 05, 2022 14:36

  - 0 +
• 

  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

  CJMartin January 07, 2022 09:19

  - 0 +

Add comment

Please sign in to leave a comment.