AnsweredAssumed Answered

SQL QUERY TO PI SYSTEM

Question asked by KrystianSobotka on Jul 2, 2019
Latest reply on Jul 15, 2019 by Zenithjnjsupport

I have a problem with a sql query.

/SQL="SELECT TOP 10 valid_compensated_thicknesses.sent_time AS PI_TIMESTAMP, convert(float,valid_compensated_thicknesses.display_thickness) AS PI_VALUE, 0 AS PI_STATUS FROM static_test_points INNER JOIN valid_compensated_thicknesses ON static_test_points.id = valid_compensated_thicknesses.measurement_point_id WHERE static_test_points.sensors_name = 'GAMD' ORDER BY valid_compensated_thicknesses.sent_time DESC;"

If i use this query in sql server management i got a good data, but if i added this query to pi point in Exdesc, it does not work. Could you help me how to solve this problem?

Im using  RDBMSPI.exr version 3.20.6.0

UniInt version 4.5.5.22

Attachments

Outcomes