Fixing MySQL query parsing bug for IoTRelation; adjusting MySQL queries for new inter...

[iot2.git] / localconfig / mysql / roomMainBulbRel.config

diff --git a/localconfig/mysql/roomMainBulbRel.config b/localconfig/mysql/roomMainBulbRel.config
index 5f82a4b58a9e1ec6201f2a7baa5dc4ad986ce7e3..1b94d1492913ad15e1bccb5ba532f124e0200966 100644 (file)
--- a/localconfig/mysql/roomMainBulbRel.config
+++ b/localconfig/mysql/roomMainBulbRel.config
@@ -1,6 +1,8 @@
 SELECT RELATION FROM
 FIRST
-Room
+RoomSmart
 OTHER
-LightBulb
+LightBulbSmart
+WHERE
+TYPE_SOURCE LIKE 'LabRoom%' 
 ;