1 Reply Latest reply on Feb 8, 2016 1:57 PM by Rashmi

    QUery not runing properly

    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