Have sql sensor count value number columns of document. Value Changed and notification not work.
"If Sensor Message Changes Ignore changes Trigger change notification"
Article Comments
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.
Aug, 2016 - Permalink
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.
Aug, 2016 - Permalink