Data Tables

From Open Source Controls Wiki
Jump to navigation Jump to search

The following table is an embedded MQTT Data Table. It is a web page that subscribes to MQTT data and shows incoming messages in a table format.

Data in the table is updated in real-time as it lands on the server. Right click on data to access historical graphs.

This type of report uses MQTT security to subscribe to data, and can be sent to someone as a stand-alone html file, that whenever opened will log onto the server and start displaying data.



The data subscribed to is specified in the show field in the URL when calling the page. For example, to show all flow temperatures from all systems on a network (tilhiu) one would use...

https://hwwiki.ddns.net/section/livetable?show=tilhiu///dat/tH&basic=1 

This is based on the standard 5 level MQTT Topic Structure used throughout software for interoperability.

network / node / device / data_group / dat_key

In standard MQTT form we would normally use + signs as wildcards:

tilhiu/+/+/dat/tH

As + signs are not used in URLs, we remove them to get the following topic:

tilhiu///dat/tH

To specify more than one filter, simply comma separate them in the URL as follows (adding return temperatures):

tilhiu///dat/tH,tilhiu///dat/tHoDHW,tilhiu///dat/tHoCH

https://hwwiki.ddns.net/section/livetable?show=tilhiu///dat/tH,tilhiu///dat/tHoDHW,tilhiu///dat/tHoCH&basic=1