Missing suggestions in subquery

DanielDohnfors · November 19, 2019 8:25AM

Table ConsultRefs has a column named PatientID. When i start typing PatientID in the subquery i only get suggestions from the table in the subquery, not from the table in the outer query.

Image: https://us.v-cdn.net/6029854/uploads/editor/5b/mia3h7d5ophe.png

Version 10.0.1.12389

Jessica R · November 23, 2019 1:35AM

Thanks for your post, @DanielDohnfors!

I'm able to reproduce this issue. Please bear with us while we investigate.

Jessica R · November 25, 2019 8:09PM

Just a quick update that we've logged this issue with reference SP-7891. Thanks for bringing it to our attention!

I'll post here once we have another update.

Jessica R · December 12, 2019 2:44AM

Hi @DanielDohnfors! I'm happy to report that this issue is resolved in the latest version of SQL Prompt, v10.0.5, released today.

Hope that helps but please let us know if any issues remain for you!

Missing suggestions in subquery

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk