AnsweredAssumed Answered

SQL issue

Question asked by Rashmi on Feb 16, 2016
Latest reply on Feb 19, 2016 by Rashmi

Hi ,

 

We have PIPOINT defined on AF for some of the attributes currently and the data is reading from SMT OK. But when I run the below query, my sql does not fetch me correct archive values.

For F4402T0001H0080, the archive values are shown for 4 columns, but the script output populating as NaN

Again, I placed the same query inside powerhell script, the output values are displaying as NaN for all 3 windtowers.

For the columns, pipoint has defined, should display me Archive values from SMT, and for other columns as NaN as they do not have Tag available. Instead for all 3 windtower , all attributes are populating as NaN.

 

Please can anyone advise me if any problem with my sql query?

Outcomes