iot_datasourse 中的历史数据仪表盘

物联网 传感器 可视化 节点红色
2021-06-01 08:23:04

我将历史数据存储在 SQL 数据库中作为日期格式 (2017.10.27 12:00:25) 和格式 (26.55) 中的相应温度。我正在使用节点 iot_datasourse 显示数据,调试消息显示时间和相应的温度,但仪表板没有显示任何图形。

流节点如下,我希望得到一些帮助

 [  
   {  
      "id":"3eeefbee.524fa4",
      "type":"iot-datasource",
      "z":"a287c70.b313638",
      "name":"Temperature_historical_data",
      "tstampField":"tstamp",
      "dataField":"data",
      "disableDiscover":false,
      "x":760,
      "y":1580,
      "wires":[  
         [  
            "c63ec7ee.45bef8"
         ]
      ]
   },
   {  
      "id":"19f7ecaf.b15d73",
      "type":"function",
      "z":"a287c70.b313638",
      "name":"Temp",
      "func":"var p =msg.payload;\n\nfor(var i=0;i<p.length;i++){\n    var dUnix =Date.parse(p[i].Datum);\n    node.send({payload:{data:p[i].Temp, tstamp:dUnix}});\n}\nreturn;",
      "outputs":1,
      "noerr":0,
      "x":550,
      "y":1580,
      "wires":[  
         [  
            "3eeefbee.524fa4",
            "9ac5be07.61cb7"
         ]
      ]
   },
   {  
      "id":"3ff59acb.6fa9d6",
      "type":"MSSQL",
      "z":"a287c70.b313638",
      "mssqlCN":"e1823c68.173aa",
      "name":"database_sql",
      "query":"",
      "outField":"payload",
      "x":390,
      "y":1580,
      "wires":[  
         [  
            "19f7ecaf.b15d73"
         ]
      ]
   },
   {  
      "id":"df2d6585.9e5338",
      "type":"inject",
      "z":"a287c70.b313638",
      "name":"",
      "topic":"",
      "payload":"SELECT * FROM [test].[Temp]",
      "payloadType":"str",
      "repeat":"",
      "crontab":"",
      "once":false,
      "onceDelay":0.1,
      "x":170,
      "y":1580,
      "wires":[  
         [  
            "3ff59acb.6fa9d6"
         ]
      ]
   },
   {  
      "id":"9ac5be07.61cb7",
      "type":"debug",
      "z":"a287c70.b313638",
      "name":"",
      "active":true,
      "tosidebar":true,
      "console":false,
      "tostatus":false,
      "complete":"false",
      "x":730,
      "y":1500,
      "wires":[  

      ]
   },
   {  
      "id":"c63ec7ee.45bef8",
      "type":"debug",
      "z":"a287c70.b313638",
      "name":"",
      "active":true,
      "tosidebar":true,
      "console":false,
      "tostatus":false,
      "complete":"false",
      "x":970,
      "y":1500,
      "wires":[  

      ]
   },
   {  
      "id":"e1823c68.173aa",
      "type":"MSSQL-CN",
      "z":"",
      "name":"SQL",
      "server":"localhost",
      "encyption":true,
      "database":"test"
   }
]
0个回答
没有发现任何回复~