Snippets are not picked as the first suggestion in the quick list

sdks · July 11, 2019 7:03AM

I expect to snippets be the first option when you type. For example here after hitting "d" then TAB it is expected that snippet would be inserted instead of suggested object.

SQL Prompt 9.5.9.10716

SSMS v17.9.1

Image: https://us.v-cdn.net/6029854/uploads/editor/wz/nxdka1tp2eq3.png

Tianjiao_Li · July 12, 2019 11:36AM

Can you please post this suggestion on our user voice forum https://redgate.uservoice.com/forums/94413-sql-prompt

sdks · July 16, 2019 2:09PM

@Tianjiao_Li this sounds to me more than a bug rather than suggestion. It worked OK previously, something happened.

Tianjiao_Li · July 17, 2019 1:15PM

Do you happen to remember the previously working version number?

Thanks.

sdks · July 18, 2019 11:31AM

nope, but I'm doing all updates straight away and it was working a month ago.

sdks · July 18, 2019 11:33AM

This is an example. Running on different instances, but the databases are more or less the same (99%). The automatically picked up object exists on both instances.

Image: https://us.v-cdn.net/6029854/uploads/editor/lt/0inoawifir9e.gif

Tianjiao_Li · July 23, 2019 9:01AM

The order in which suggestions are listed depends on the context of your query. More information can be found https://documentation.red-gate.com/sp9/speeding-up-your-queries/inserting-suggestions-into-your-code

Tianjiao_Li · July 24, 2019 8:43AM

@sdks Can you turn off 'Show most recently used suggestions at the top of the list' which is new feature turned on by default? Does it help?

Image: https://us.v-cdn.net/6029854/uploads/editor/n4/rjsln46qk186.png

sdks · July 26, 2019 8:48AM

that helped

wdg · October 31, 2019 5:16PM

I don't want to turn that setting off! It is useful to see most recent suggestions.
But in case of the entered string matches a snippet then the snippet should be the first.
Why I need to scroll or search my snippet in the list?
Snippets should not work this way, but should provide a fast and convenient tool to enter text.

TomW · November 1, 2019 2:08PM

Hi @wdg

We've recently introduced "Ranked Suggestions" in SQL Prompt 9.5.21, which puts snippets to the top if it's an exact match with what you've typed. Please don't hesitate to get it touch if you're still having issues on that version.

Thanks,

Tom
Team Prompt

wdg · November 4, 2019 2:36PM

Hi @TomW,
I use version 9.5.23 and just made a screenshot similar to sdks's at the top. (Not so nice though):

Image: https://us.v-cdn.net/6029854/uploads/editor/9p/yxhxrfzwhbbc.png

It can be clearly seen that I entered a snippet ("sst") and is listed as the second item in the recommendations list despite it has an exact matched snippet.

Image: https://us.v-cdn.net/6029854/uploads/editor/7y/cno0ofwlgevw.png

Tianjiao_Li · November 21, 2019 11:06AM

@wdg

Thanks for the screenshot.

I've reproduced it and the development team is investigating it now.

I'll keep here posted.

Tianjiao_Li · December 5, 2019 8:58AM

@wdg

The fix is shipped in 10.0.3 so please upgrade when you can.

Snippets are not picked as the first suggestion in the quick list

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk