Have sql sensor count value number columns of document. Value Changed and notification not work.
"If Sensor Message Changes Ignore changes Trigger change notification"
SQL notification.
Votes:
0
3 Replies
Votes:
0
Dear East
The change trigger evaluates the sensor status message. Since the message is by default "OK", please use the sensor option to configure a custom status message. You can use values from the SQL result, meaning the row count now should be done directly with an according SQL statement.
Created on Aug 22, 2016 12:06:01 PM by
Votes:
0
Dear East
To make this setting workable, you first have to change the SQL statement to return the row count as a table. You can now provide row number and access the data in the first column of that row of that table. The first row of that table is represented by the placeholder {0}. (And again, always the first column is used.)
Please note that the current 16.3.25 release has a bug which leads to showing "Ok" instead of the actual value. This will be fixed in the upcoming 16.3.26 release.
Created on Aug 22, 2016 1:35:54 PM by
Last change on Aug 22, 2016 2:27:03 PM by
Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.
Add comment