AnsweredAssumed Answered

QUery not runing properly

Question asked by Rashmi on Feb 8, 2016
Latest reply on Feb 8, 2016 by Rashmi

Hi,

 

can someone correct me please what's wrong in this query?

 

SELECT substr(eh.Name,1,5) farmcode,eh.Name latlongmap, tc.height,

if tc.speed is null then 'NaN' else cast (tc.speed as variant) as speed,

tc.temperature,tc.outpower,tc.state

FROM (SELECT Date('07/02/2016') Time) t, [HYREF].[Asset].[ElementHierarchy] eh

     CROSS APPLY [HYREF].[DataT].[TransposeInterpolateDiscrete_WindGeneratorTemplate](eh.ElementID, t.Time) tc

 

     WHERE eh.Path like '%\%' and eh.Name like 'F4402W0001H0080'

order by latlongmap

     OPTION (FORCE ORDER, IGNORE ERRORS, EMBED ERRORS)

 

in this query state and temperature values are not appearing, although PI tags have been defined on explorer window correctly.

 

Even if I say 'NaN' as speed, still state and temp values are not displaying in result set.

 

PS: Since there is no PI point available for 'speed' attribute, I should set as NaN fo speed and all other values should disply me.

 

Regards,Rashmi

 

 

Attachments

Outcomes