AnsweredAssumed Answered

PI SQL Commander Query Help

Question asked by sweta.agarwal on May 19, 2017
Latest reply on May 24, 2017 by sweta.agarwal

SELECT eh.Path + eh.Name Element, tir.[Time], tir.[Outside Air Temp],tir.[Return Air Temp],tir.[Mixed Air Temp],tir.[Supply Air Temp Sp],tir.[ACE Rule 1]

FROM [ACE].[Asset].[ElementTemplate] et

INNER JOIN [ACE].[Asset].[Element] e

     ON et.ID = e.ElementTemplateID

INNER JOIN [ACE].[Asset].[ElementHierarchy] eh

     ON e.ID = eh.ElementID

CROSS APPLY [ACE].[DataT].[TransposeInterpolateRange_ICS: OFC AHU]

(

     eh.ElementID,

     DATE(N'2017-04-15'),    /*StartTime*/

     DATE(N't'),        /*EndTime*/

     N'1h'            /*TimeStep*/

) tir

WHERE et.Name = N'ICS: OFC AHU'

OPTION (FORCE ORDER, IGNORE ERRORS, EMBED ERRORS)

 

I am trying to use AND WHERE eh.Path like '%zyz%'

 

However it is giving me this error -> Extraneous '.', expecting <IDENTIFIER>

 

Can someone help me in customizing this query?

 

 

Outcomes