Hello:
Looking for some help with filtering table data. I am populating a ui_table and two ui_dropdown nodes from a SQL database. The table works fine as long as I don't switch tabs. When I switch tabs, the table data disappears and I have to refresh the queries to get the data (until I switch tabs again). However, if I disable the function nodes that create the setFilter/clearFilter commands, the data does not disappear, so I'm guessing it's got something to do with how I'm using that command.
Below is the flow. The data can be populated by the triggering from the inject node. Please note that the behavior occurs ONLY if you switch tabs, so if you are testing this, please create another tab and switch between the two. Hopefully, I'm missing something simple.
Thanks for your help.
[{"id":"3e063e21.96519a","type":"inject","z":"5e2453b7.c3e99c","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":496.3332824707031,"y":1132,"wires":[["ae74e89b.f901b","1b2e0437.8c848c","6059a5c8.157e6c","777307da.a092f"]]},{"id":"ae74e89b.f901b","type":"change","z":"5e2453b7.c3e99c","name":"Log Detail Data","rules":[{"t":"set","p":"payload","pt":"msg","to":"[{\"Date\":\"2021-05-31 16:57:06\",\"Time\":\"2021-05-31 16:57:06\",\"Type\":\"dev\",\"Device\":\"Upstairs Filing Cabinet\",\"Detail\":\"Upstairs Filing Cabinet is off\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 16:55:44\",\"Time\":\"2021-05-31 16:55:44\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor illuminance is 59 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 16:54:53\",\"Time\":\"2021-05-31 16:54:53\",\"Type\":\"dev\",\"Device\":\"Upstairs Desk Lamp\",\"Detail\":\"Upstairs Desk Lamp is off\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 16:45:45\",\"Time\":\"2021-05-31 16:45:45\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor illuminance is 60 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 16:40:44\",\"Time\":\"2021-05-31 16:40:44\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor illuminance is 50 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 16:35:44\",\"Time\":\"2021-05-31 16:35:44\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor illuminance is 65 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 16:30:45\",\"Time\":\"2021-05-31 16:30:45\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor illuminance is 103 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 16:25:45\",\"Time\":\"2021-05-31 16:25:45\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor illuminance is 117 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 16:22:39\",\"Time\":\"2021-05-31 16:22:39\",\"Type\":\"dev\",\"Device\":\"Front Lock\",\"Detail\":\"Front Lock is locked\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 16:22:17\",\"Time\":\"2021-05-31 16:22:17\",\"Type\":\"dev\",\"Device\":\"Front Lock\",\"Detail\":\"Front Lock was locked via keypad[6:5]\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 16:22:07\",\"Time\":\"2021-05-31 16:22:07\",\"Type\":\"dev\",\"Device\":\"Front Lock\",\"Detail\":\"Front Lock was manually unlocked [physical][6:2]\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 16:21:01\",\"Time\":\"2021-05-31 16:21:01\",\"Type\":\"dev\",\"Device\":\"Garage Tilt Sensor\",\"Detail\":\"Garage Tilt Sensor was closed\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 16:20:45\",\"Time\":\"2021-05-31 16:20:45\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor illuminance is 72 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 16:19:58\",\"Time\":\"2021-05-31 16:19:58\",\"Type\":\"dev\",\"Device\":\"Front Lock\",\"Detail\":\"Front Lock is locked\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 16:19:36\",\"Time\":\"2021-05-31 16:19:36\",\"Type\":\"dev\",\"Device\":\"Garage Tilt Sensor\",\"Detail\":\"Garage Tilt Sensor was opened\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 16:19:26\",\"Time\":\"2021-05-31 16:19:26\",\"Type\":\"dev\",\"Device\":\"Garage Lock\",\"Detail\":\"Garage Lock was unlocked manually [physical][22]\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 16:15:46\",\"Time\":\"2021-05-31 16:15:46\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor illuminance is 92 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 16:10:45\",\"Time\":\"2021-05-31 16:10:45\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor illuminance is 57 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 16:05:46\",\"Time\":\"2021-05-31 16:05:46\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor illuminance is 38 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 16:00:46\",\"Time\":\"2021-05-31 16:00:46\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor illuminance is 31 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 15:55:45\",\"Time\":\"2021-05-31 15:55:45\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor illuminance is 38 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 15:50:46\",\"Time\":\"2021-05-31 15:50:46\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor illuminance is 63 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 15:45:46\",\"Time\":\"2021-05-31 15:45:46\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor illuminance is 79 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 15:40:45\",\"Time\":\"2021-05-31 15:40:45\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor illuminance is 128 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 15:36:11\",\"Time\":\"2021-05-31 15:36:11\",\"Type\":\"dev\",\"Device\":\"Virtual Couch Lamp Lux\",\"Detail\":\"Virtual Couch Lamp Lux was turned on\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 15:35:58\",\"Time\":\"2021-05-31 15:35:58\",\"Type\":\"dev\",\"Device\":\"Front Lock\",\"Detail\":\"Front Lock is locked\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 15:35:44\",\"Time\":\"2021-05-31 15:35:44\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor illuminance is 306 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 15:35:32\",\"Time\":\"2021-05-31 15:35:32\",\"Type\":\"dev\",\"Device\":\"Front Lock\",\"Detail\":\"Front Lock was manually locked [physical][6:1]\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 15:35:26\",\"Time\":\"2021-05-31 15:35:26\",\"Type\":\"dev\",\"Device\":\"Front Lock\",\"Detail\":\"Front Lock was unlocked by Chitra[6:6]\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 15:30:44\",\"Time\":\"2021-05-31 15:30:44\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor illuminance is 567 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 15:25:48\",\"Time\":\"2021-05-31 15:25:48\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor illuminance is 782 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 15:20:44\",\"Time\":\"2021-05-31 15:20:44\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor illuminance is 460 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 15:18:24\",\"Time\":\"2021-05-31 15:18:24\",\"Type\":\"dev\",\"Device\":\"Kitchen Switch\",\"Detail\":\"Kitchen Switch: Energy report received with value of 133.298 kWh\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 15:15:49\",\"Time\":\"2021-05-31 15:15:49\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor illuminance is 667 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 15:10:49\",\"Time\":\"2021-05-31 15:10:49\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor illuminance is 462 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 15:10:43\",\"Time\":\"2021-05-31 15:10:43\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor illuminance is 405 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 15:08:57\",\"Time\":\"2021-05-31 15:08:57\",\"Type\":\"dev\",\"Device\":\"Virtual Couch Lamp Lux\",\"Detail\":\"Virtual Couch Lamp Lux was turned off\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 15:08:22\",\"Time\":\"2021-05-31 15:08:22\",\"Type\":\"dev\",\"Device\":\"Front Lock\",\"Detail\":\"Front Lock is locked\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 15:07:57\",\"Time\":\"2021-05-31 15:07:57\",\"Type\":\"dev\",\"Device\":\"Front Lock\",\"Detail\":\"Front Lock was locked via keypad[6:5]\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 15:07:50\",\"Time\":\"2021-05-31 15:07:50\",\"Type\":\"dev\",\"Device\":\"Front Lock\",\"Detail\":\"Front Lock was manually unlocked [physical][6:2]\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 15:05:50\",\"Time\":\"2021-05-31 15:05:50\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor illuminance is 399 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 15:05:42\",\"Time\":\"2021-05-31 15:05:42\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor illuminance is 301 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 15:04:07\",\"Time\":\"2021-05-31 15:04:07\",\"Type\":\"dev\",\"Device\":\"Virtual Couch Lamp Lux\",\"Detail\":\"Virtual Couch Lamp Lux was turned on\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 15:00:50\",\"Time\":\"2021-05-31 15:00:50\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor illuminance is 572 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 14:55:50\",\"Time\":\"2021-05-31 14:55:50\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor illuminance is 736 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 14:55:43\",\"Time\":\"2021-05-31 14:55:43\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor illuminance is 433 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 14:50:51\",\"Time\":\"2021-05-31 14:50:51\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor illuminance is 1208 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 14:50:42\",\"Time\":\"2021-05-31 14:50:42\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor illuminance is 476 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 14:48:15\",\"Time\":\"2021-05-31 14:48:15\",\"Type\":\"dev\",\"Device\":\"Virtual Bookcase Lux\",\"Detail\":\"Virtual Bookcase Lux was turned on\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 14:45:50\",\"Time\":\"2021-05-31 14:45:50\",\"Type\":\"dev\",\"Device\":\"Virtual Entryway Lux\",\"Detail\":\"Virtual Entryway Lux was turned on\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 14:45:42\",\"Time\":\"2021-05-31 14:45:42\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor illuminance is 675 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 14:40:52\",\"Time\":\"2021-05-31 14:40:52\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor illuminance is 1460 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 14:40:41\",\"Time\":\"2021-05-31 14:40:41\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor illuminance is 864 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 14:37:52\",\"Time\":\"2021-05-31 14:37:52\",\"Type\":\"dev\",\"Device\":\"Living Room 2\",\"Detail\":\"Living Room 2 is 100% [physical]\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 14:30:52\",\"Time\":\"2021-05-31 14:30:52\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor illuminance is 1918 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 14:25:42\",\"Time\":\"2021-05-31 14:25:42\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor illuminance is 1170 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 14:23:26\",\"Time\":\"2021-05-31 14:23:26\",\"Type\":\"dev\",\"Device\":\"Bedroom Button\",\"Detail\":\"Bedroom Button temperature is 72.61°F\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 14:22:21\",\"Time\":\"2021-05-31 14:22:21\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor temperature is 71.77°F\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 14:20:53\",\"Time\":\"2021-05-31 14:20:53\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor illuminance is 1476 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 14:20:42\",\"Time\":\"2021-05-31 14:20:42\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor illuminance is 971 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 14:18:14\",\"Time\":\"2021-05-31 14:18:14\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor is inactive\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 14:15:53\",\"Time\":\"2021-05-31 14:15:53\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor illuminance is 1896 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 14:15:42\",\"Time\":\"2021-05-31 14:15:42\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor illuminance is 1227 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 14:13:21\",\"Time\":\"2021-05-31 14:13:21\",\"Type\":\"dev\",\"Device\":\"Virtual LED Notification 3\",\"Detail\":\"Virtual LED Notification 3 was turned on\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 14:11:48\",\"Time\":\"2021-05-31 14:11:48\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor is active\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 14:10:53\",\"Time\":\"2021-05-31 14:10:53\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor illuminance is 1426 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 14:10:05\",\"Time\":\"2021-05-31 14:10:05\",\"Type\":\"dev\",\"Device\":\"Virtual Entryway Lux\",\"Detail\":\"Virtual Entryway Lux was turned off\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 14:08:45\",\"Time\":\"2021-05-31 14:08:45\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor temperature is 70.17°F\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 14:07:21\",\"Time\":\"2021-05-31 14:07:21\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor temperature is 70.76°F\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 13:53:43\",\"Time\":\"2021-05-31 13:53:43\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor temperature is 69.16°F\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 13:50:54\",\"Time\":\"2021-05-31 13:50:54\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor illuminance is 1182 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 13:47:16\",\"Time\":\"2021-05-31 13:47:16\",\"Type\":\"dev\",\"Device\":\"Garage Tilt Sensor\",\"Detail\":\"Garage Tilt Sensor battery is 100%\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 13:45:38\",\"Time\":\"2021-05-31 13:45:38\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor illuminance is 957 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 13:42:23\",\"Time\":\"2021-05-31 13:42:23\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor temperature is 69.75°F\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 13:40:38\",\"Time\":\"2021-05-31 13:40:38\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor illuminance is 744 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 13:30:56\",\"Time\":\"2021-05-31 13:30:56\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor illuminance is 1027 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 13:25:56\",\"Time\":\"2021-05-31 13:25:56\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor illuminance is 1160 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 13:07:25\",\"Time\":\"2021-05-31 13:07:25\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor temperature is 68.72°F\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 13:05:56\",\"Time\":\"2021-05-31 13:05:56\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor illuminance is 978 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 13:04:18\",\"Time\":\"2021-05-31 13:04:18\",\"Type\":\"dev\",\"Device\":\"Mailbox Contact Sensor\",\"Detail\":\"Mailbox Contact Sensor battery is 99%\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 13:01:40\",\"Time\":\"2021-05-31 13:01:40\",\"Type\":\"dev\",\"Device\":\"Virtual Entryway Lux\",\"Detail\":\"Virtual Entryway Lux was turned on\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 13:00:56\",\"Time\":\"2021-05-31 13:00:56\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor illuminance is 1210 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 13:00:35\",\"Time\":\"2021-05-31 13:00:35\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor illuminance is 625 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 12:55:55\",\"Time\":\"2021-05-31 12:55:55\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor illuminance is 1718 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 12:55:34\",\"Time\":\"2021-05-31 12:55:34\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor illuminance is 850 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 12:53:38\",\"Time\":\"2021-05-31 12:53:38\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor temperature is 68.13°F\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 12:50:56\",\"Time\":\"2021-05-31 12:50:56\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor illuminance is 2080 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 12:50:35\",\"Time\":\"2021-05-31 12:50:35\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor illuminance is 1171 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 12:46:30\",\"Time\":\"2021-05-31 12:46:30\",\"Type\":\"dev\",\"Device\":\"Virtual Bookcase Lux\",\"Detail\":\"Virtual Bookcase Lux was turned off\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 12:45:56\",\"Time\":\"2021-05-31 12:45:56\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor illuminance is 1474 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 12:45:35\",\"Time\":\"2021-05-31 12:45:35\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor illuminance is 1111 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 12:40:56\",\"Time\":\"2021-05-31 12:40:56\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor illuminance is 709 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 12:40:36\",\"Time\":\"2021-05-31 12:40:36\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor illuminance is 713 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 12:40:18\",\"Time\":\"2021-05-31 12:40:18\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor is inactive\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 12:35:56\",\"Time\":\"2021-05-31 12:35:56\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor illuminance is 581 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 12:35:36\",\"Time\":\"2021-05-31 12:35:36\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor illuminance is 471 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 12:35:05\",\"Time\":\"2021-05-31 12:35:05\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor is active\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 12:32:31\",\"Time\":\"2021-05-31 12:32:31\",\"Type\":\"dev\",\"Device\":\"TV Room Button\",\"Detail\":\"TV Room Button temperature is 73.30°F\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 12:30:56\",\"Time\":\"2021-05-31 12:30:56\",\"Type\":\"dev\",\"Device\":\"Backyard Motion Sensor\",\"Detail\":\"Backyard Motion Sensor illuminance is 795 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 12:30:35\",\"Time\":\"2021-05-31 12:30:35\",\"Type\":\"dev\",\"Device\":\"Entryway Motion Sensor\",\"Detail\":\"Entryway Motion Sensor illuminance is 440 Lux\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 12:22:36\",\"Time\":\"2021-05-31 12:22:36\",\"Type\":\"dev\",\"Device\":\"Front Lock\",\"Detail\":\"Front Lock is locked\",\"Level\":\"info\"},{\"Date\":\"2021-05-31 12:22:11\",\"Time\":\"2021-05-31 12:22:11\",\"Type\":\"dev\",\"Device\":\"Front Lock\",\"Detail\":\"Front Lock was manually locked [physical][6:1]\",\"Level\":\"info\"}]","tot":"json"}],"action":"","property":"","from":"","to":"","reg":false,"x":707.3332366943359,"y":1098.9999694824219,"wires":[["feb92447.41da88"]]},{"id":"1b2e0437.8c848c","type":"change","z":"5e2453b7.c3e99c","name":"Log Count Data","rules":[{"t":"set","p":"payload","pt":"msg","to":"{\"count(1)\":257}","tot":"json"}],"action":"","property":"","from":"","to":"","reg":false,"x":701.6666107177734,"y":1041.6665344238281,"wires":[["63529c1f.b93104"]]},{"id":"6059a5c8.157e6c","type":"change","z":"5e2453b7.c3e99c","name":"Log Device Data","rules":[{"t":"set","p":"payload","pt":"msg","to":"[{\"value\":\"Backyard Motion Sensor\",\"label\":\"Backyard Motion Sensor\"},{\"value\":\"Bedroom Button\",\"label\":\"Bedroom Button\"},{\"value\":\"Couch Lamp\",\"label\":\"Couch Lamp\"},{\"value\":\"Entryway Motion Sensor\",\"label\":\"Entryway Motion Sensor\"},{\"value\":\"Front Lock\",\"label\":\"Front Lock\"},{\"value\":\"Garage Lock\",\"label\":\"Garage Lock\"},{\"value\":\"Garage Tilt Sensor\",\"label\":\"Garage Tilt Sensor\"},{\"value\":\"Hubitat Package Manager\",\"label\":\"Hubitat Package Manager\"},{\"value\":\"Kitchen Switch\",\"label\":\"Kitchen Switch\"},{\"value\":\"Living Room 2\",\"label\":\"Living Room 2\"},{\"value\":\"Mailbox Contact Sensor\",\"label\":\"Mailbox Contact Sensor\"},{\"value\":\"TV Room Button\",\"label\":\"TV Room Button\"},{\"value\":\"Upstairs Desk Lamp\",\"label\":\"Upstairs Desk Lamp\"},{\"value\":\"Upstairs Filing Cabinet\",\"label\":\"Upstairs Filing Cabinet\"},{\"value\":\"Virtual Bookcase Lux\",\"label\":\"Virtual Bookcase Lux\"},{\"value\":\"Virtual Couch Lamp Lux\",\"label\":\"Virtual Couch Lamp Lux\"},{\"value\":\"Virtual Entry Way AM\",\"label\":\"Virtual Entry Way AM\"},{\"value\":\"Virtual Entryway Lux\",\"label\":\"Virtual Entryway Lux\"},{\"value\":\"Virtual LED Notification 1\",\"label\":\"Virtual LED Notification 1\"},{\"value\":\"Virtual LED Notification 3\",\"label\":\"Virtual LED Notification 3\"},{\"value\":\"Virtual Ring Motion\",\"label\":\"Virtual Ring Motion\"},{\"value\":\"Virtual Ring Motion Trigger\",\"label\":\"Virtual Ring Motion Trigger\"},{\"value\":\"X - Paired Unsed Door Sensor\",\"label\":\"X - Paired Unsed Door Sensor\"}]","tot":"json"}],"action":"","property":"","from":"","to":"","reg":false,"x":720.6665954589844,"y":1161.6666259765625,"wires":[["647ecd26.1ac3e4"]]},{"id":"777307da.a092f","type":"change","z":"5e2453b7.c3e99c","name":"Log Level Data","rules":[{"t":"set","p":"payload","pt":"msg","to":"[{\"value\":\"debug\",\"label\":\"debug\"},{\"value\":\"info\",\"label\":\"info\"}]","tot":"json"}],"action":"","property":"","from":"","to":"","reg":false,"x":690.6665954589844,"y":1233.3333740234375,"wires":[["755b9f2e.cddaf8"]]},{"id":"feb92447.41da88","type":"change","z":"5e2453b7.c3e99c","name":"ui_control","rules":[{"t":"set","p":"ui_control","pt":"msg","to":"{\"tabulator\":{\"layout\":\"fitDataTable\",\"columns\":[{\"title\":\"Row\",\"field\":\"row_id\",\"formatter\":\"rownum\",\"width\":\"10%\"},{\"formatter\":\"datetime\",\"formatterParams\":{\"inputFormat\":\"YYYY-MM-DD HH:mm:ss\",\"outputFormat\":\"YYYY-MM-DD\",\"invalidPlaceholder\":\"(invalid date)\"},\"title\":\"Date\",\"field\":\"Date\",\"width\":\"10%\"},{\"formatter\":\"datetime\",\"formatterParams\":{\"inputFormat\":\"YYYY-MM-DD HH:mm:ss\",\"outputFormat\":\"hh:mm:ss A\",\"invalidPlaceholder\":\"(invalid time)\"},\"title\":\"Time\",\"field\":\"Time\",\"width\":\"10%\"},{\"title\":\"Level\",\"field\":\"Level\",\"width\":\"10%\"},{\"title\":\"Device\",\"field\":\"Device\",\"width\":\"20%\"},{\"title\":\"Detail\",\"field\":\"Detail\",\"width\":\"30%\"},{\"title\":\"Type\",\"field\":\"Type\",\"width\":\"10%\"}]}}","tot":"json"}],"action":"","property":"","from":"","to":"","reg":false,"x":1117.666748046875,"y":1056.3334045410156,"wires":[["acf79464.491cb8"]]},{"id":"63529c1f.b93104","type":"change","z":"5e2453b7.c3e99c","name":"Array2String","rules":[{"t":"set","p":"payload","pt":"msg","to":"payload[0].count(1)","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":1122.6666259765625,"y":977.3334045410156,"wires":[["c5fe6d2a.058538"]]},{"id":"647ecd26.1ac3e4","type":"switch","z":"5e2453b7.c3e99c","name":"Selection = 1?","property":"$count(payload)","propertyType":"jsonata","rules":[{"t":"eq","v":"1","vt":"num"},{"t":"gt","v":"1","vt":"num"}],"checkall":"true","repair":false,"outputs":2,"x":1117.3334197998047,"y":1146.6667861938477,"wires":[["81d69fea.97f42"],["6696c56e.19cc6c"]]},{"id":"755b9f2e.cddaf8","type":"switch","z":"5e2453b7.c3e99c","name":"Selection = 1?","property":"$count(payload)","propertyType":"jsonata","rules":[{"t":"eq","v":"1","vt":"num"},{"t":"gt","v":"1","vt":"num"}],"checkall":"true","repair":false,"outputs":2,"x":1111.999984741211,"y":1282.666898727417,"wires":[["8fabaceb.332bb"],["2842b927.514efe"]]},{"id":"acf79464.491cb8","type":"ui_table","z":"5e2453b7.c3e99c","group":"9aa62032.6ecb9","name":"Logs Table","order":5,"width":"26","height":"16","columns":[],"outputs":0,"cts":false,"x":2272.667526245117,"y":1049.33345413208,"wires":[],"inputLabels":["Events"]},{"id":"c5fe6d2a.058538","type":"ui_text","z":"5e2453b7.c3e99c","group":"a4f9c1dc.c51478","order":4,"width":"6","height":"1","name":"","label":"Total Logged Events:","format":"{{msg.payload}}","layout":"row-left","x":1344.6666259765625,"y":977.3334045410156,"wires":[]},{"id":"81d69fea.97f42","type":"change","z":"5e2453b7.c3e99c","name":"Set Dropdown Selection = 1","rules":[{"t":"set","p":"options[0]","pt":"msg","to":"payload.value","tot":"jsonata"},{"t":"set","p":"payload[0]","pt":"msg","to":"payload.value","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":1355.9999237060547,"y":1107.3334350585938,"wires":[["fac6cd5a.423ae8"]]},{"id":"6696c56e.19cc6c","type":"change","z":"5e2453b7.c3e99c","name":"Set Dropdown Selection > 1","rules":[{"t":"set","p":"options","pt":"msg","to":"payload.value","tot":"jsonata"},{"t":"set","p":"payload","pt":"msg","to":"payload.value","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":1357.6665496826172,"y":1166.0000305175781,"wires":[["fac6cd5a.423ae8"]]},{"id":"8fabaceb.332bb","type":"change","z":"5e2453b7.c3e99c","name":"Set Dropdown Selection = 1","rules":[{"t":"set","p":"options[0]","pt":"msg","to":"payload.value","tot":"jsonata"},{"t":"set","p":"payload[0]","pt":"msg","to":"payload.value","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":1345.3336639404297,"y":1237.3334934711456,"wires":[["c22872da.7238a"]]},{"id":"2842b927.514efe","type":"change","z":"5e2453b7.c3e99c","name":"Set Dropdown Selection > 1","rules":[{"t":"set","p":"options","pt":"msg","to":"payload.value","tot":"jsonata"},{"t":"set","p":"payload","pt":"msg","to":"payload.value","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":1347.0000457763672,"y":1326.0001497268677,"wires":[["c22872da.7238a"]]},{"id":"97686e0e.02e42","type":"function","z":"5e2453b7.c3e99c","name":"Filter Table","func":"msg.payload={\n \"command\": \"setFilter\",\n \"arguments\": \n [\n [\n {\"field\":\"Device\", \"type\":\"in\", \"value\":msg.payload}\n ]\n ],\n returnPromise: false\n}\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":1915.333236694336,"y":1088.3333740234375,"wires":[["acf79464.491cb8"]]},{"id":"678fb8a.77a8148","type":"function","z":"5e2453b7.c3e99c","name":"Clear Filter","func":"msg.payload={\n \"command\": \"clearFilter\",\n \"arguments\": \n [\n [\n {\"field\":\"\", \"type\":\"=\", \"value\":\"\"},\n //{field:\"date_fin\", type:\"<=\", value:doy }\n ]\n ],\n returnPromise: false\n}\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":1918.999984741211,"y":1167.0000305175781,"wires":[["acf79464.491cb8"]]},{"id":"b081019b.a9e1","type":"function","z":"5e2453b7.c3e99c","name":"Filter Table","func":"msg.payload={\n \"command\": \"setFilter\",\n \"arguments\": \n [\n [\n {\"field\":\"Level\", \"type\":\"in\", \"value\":msg.payload},\n //{field:\"date_fin\", type:\"<=\", value:doy }\n ]\n ],\n returnPromise: false\n}\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":1936.333236694336,"y":1239.3334426879883,"wires":[["acf79464.491cb8"]]},{"id":"82c33825.58c218","type":"function","z":"5e2453b7.c3e99c","name":"Clear Filter","func":"msg.payload={\n \"command\": \"clearFilter\",\n \"arguments\": \n [\n [\n {\"field\":\"\", \"type\":\"=\", \"value\":\"\"},\n //{field:\"date_fin\", type:\"<=\", value:doy }\n ]\n ],\n returnPromise: false\n}\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":1941.999984741211,"y":1312.0000686645508,"wires":[["acf79464.491cb8"]]},{"id":"fac6cd5a.423ae8","type":"ui_dropdown","z":"5e2453b7.c3e99c","name":"Devices","label":"Device(s):","tooltip":"","place":"Select option","group":"a4f9c1dc.c51478","order":3,"width":"5","height":"1","passthru":true,"multiple":true,"options":[],"payload":"","topic":"topic","topicType":"msg","x":1582.6665496826172,"y":1133.0000305175781,"wires":[["67e2353e.fa45c4"]]},{"id":"c22872da.7238a","type":"ui_dropdown","z":"5e2453b7.c3e99c","name":"Log Level","label":"Log Level:","tooltip":"","place":"Select option","group":"a4f9c1dc.c51478","order":3,"width":"5","height":"1","passthru":true,"multiple":true,"options":[],"payload":"","topic":"topic","topicType":"msg","x":1581.6666107177734,"y":1278.0001831054688,"wires":[["2832223f.248756"]]},{"id":"67e2353e.fa45c4","type":"switch","z":"5e2453b7.c3e99c","name":"Data Selected?","property":"$count(payload)","propertyType":"jsonata","rules":[{"t":"gt","v":"0","vt":"num"},{"t":"eq","v":"0","vt":"num"}],"checkall":"true","repair":false,"outputs":2,"x":1755.3334197998047,"y":1133.3334350585938,"wires":[["97686e0e.02e42"],["678fb8a.77a8148"]]},{"id":"2832223f.248756","type":"switch","z":"5e2453b7.c3e99c","name":"Data Selected?","property":"$count(payload)","propertyType":"jsonata","rules":[{"t":"gt","v":"0","vt":"num"},{"t":"eq","v":"0","vt":"num"}],"checkall":"true","repair":false,"outputs":2,"x":1764.3333587646484,"y":1277.3335647583008,"wires":[["b081019b.a9e1"],["82c33825.58c218"]]},{"id":"9aa62032.6ecb9","type":"ui_group","name":"Logs Table","tab":"c0ac087.290f478","order":3,"disp":true,"width":"26","collapse":false},{"id":"a4f9c1dc.c51478","type":"ui_group","name":"Logs For:","tab":"c0ac087.290f478","order":2,"disp":true,"width":"26","collapse":false},{"id":"c0ac087.290f478","type":"ui_tab","name":"Logs","icon":"fa-cogs","order":2,"disabled":false,"hidden":false}]
