Please Fix

MikeO

This is just one example.. the intellisense does not work with the SC variable inside a Sub-Query

SELECT SC.SnomedID ,

       SC.SnomedCode AS [Code] ,

       6 AS [CodeSystem_ID] ,

       SC.SnomedDescription AS [DisplayName]

FROM   DataCenter.ref.SnomedCode AS SC

WHERE  EXISTS ( SELECT *

                FROM   DataCenter.der.fn_LoadPatientsByRequestID(3, 25) AS P

                       

                WHERE  EXISTS ( SELECT *

                                FROM   DataCenter.dbo.TobaccoUseStatus AS TUS

                                WHERE  TUS.DataCenterID = P.DataCenterID

AND TUS.CurrentStatus_ID = SC.Sn));

Tianjiao_Li

Hi @MikeO

Thanks for reporting this issue!

We have it logged as SP-7109, so please keep an eye on the release note!

Our apologies for the inconvenience caused.

Tianjiao_Li

Hi @MikeO

Please upgrade to the latest version (9.2.1.5713) which has the fix for this issue!