UI Table in Node-RED

UI Layout

Data in Maria DB

 

UI TABLE

 

 

Add Data to UI TABLE Example

var aJsonArray = new Array();

for(var i = 0; i < 10; i++)
{
    var aJson = new Object();
    aJson.ID = 0;
    aJson.temp = 0;
    aJson.humidity = 0;
    aJson.cdc = 0;
    aJson.water = 0;
    aJson.co2 = 0;
    aJson.date = "2020-01-01 00:00:00";
    aJsonArray.push(aJson);
}

var text = JSON.stringify(aJsonArray);
var obj = JSON.parse(text);
msg.payload = obj;

return msg;

node-red-contrib-stackhero-mysql

www.npmjs.com/package/node-red-contrib-stackhero-mysql

데이터베이스 리스트

 

서버에서 데이터를 가져와서 리스트에 표시합니다.

select an item from DB

Debug

data pase NODE

var aJsonArray = new Array();

for(var i = 0; i < msg.payload.length; i++)
{
    
    msg.payload[i].date = msg.payload[i].date.toLocaleString("en-US", {timeZone: "Asia/Seoul"});
    aJsonArray.push(msg.payload[i]);
}

var text = JSON.stringify(aJsonArray);
var obj = JSON.parse(text);
msg.payload = obj;

return msg;

ui_table_example_from_database.json

0.00MB