DB: Use sql '=' instead of 'like' to match ids
@@ -155,7 +155,7 @@ void DeRestPluginPrivate::createTempViews()
" WHERE a.uniqueid like b.mac || '%'",
"CREATE TEMP VIEW sensor_device_value_view "
" AS SELECT a.sid AS sensor_id, b.cluster AS cluster_id, b.data AS data, b.timestamp AS timestamp "
- " from sensor_device_view a, zcl_values b where a.id like b.device_id "
+ " from sensor_device_view a, zcl_values b where a.id = b.device_id "
" ORDER BY timestamp ASC ",
NULL
};
