dpQuery using a $dp

[AMRPatricio]

Hi all,
I am trying to use a $dp in one dpQuery. Currently having problems with the syntax.

dpQueryConnectAll("updateStatus",true,"","SELECT '_alert_hdl.._act_state_text' FROM '*.Alarm.unAck.*'WHERE _DP = \\"clifton_50\\" ");

Instead of Clifton_50 I want a $dp.

Any help?

Thanks.
Antonio

[nmnogueira]

try

Code: Select all

 dpQueryConnectAll("updateStatus",true,"","SELECT '_alert_hdl.._act_state_text' FROM '*.Alarm.unAck.*' WHERE _DP = \\""+$dp+"\\" ");

[leoknipp]

Instead of defining the datapoint in the WHERE condition you should use it in the FROM statement.
... FROM '" + $dp + ".Alarm.unAck.*' ...

Best Regards
Leopold Knipp
Senior Support Specialist

[AMRPatricio]

Thank you both.

Best regards,
Antonio