Hello I am reading a database from dashboard & want to display on dashboard on some tabs ?How it is possible through node-red dashboard?how /I can seperate array of objects?
[{"id":"ee4af54b.e5e4c8","type":"inject","z":"37600b34.10de04","name":"read from database","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":186,"y":489,"wires":[["c4044e5c.fe7ba"]]},{"id":"f15eb3f1.f9f74","type":"fieldbus in","z":"37600b34.10de04","name":"Input1","FieldbusNodeVersion":"1.2.7","WrapperVersion":"1.2.7","WrapperCompileDate":"Jan 18 2018/18:37:45","MinExpectedNodeJSVersion":"8.9.3","ActNodeJSVersion":"8.15.1","ActNodeREDVersion":"0.19.6","selectedSignalPath":"input~receive_001~Sig_1","fieldbusObj":"4942edff.af1714","x":210,"y":140,"wires":[["383cd8e4.420da8","94d2fcb9.f9209"]]},{"id":"d75ee845.03a158","type":"fieldbus in","z":"37600b34.10de04","name":"Input2","FieldbusNodeVersion":"1.2.7","WrapperVersion":"1.2.7","WrapperCompileDate":"Jan 18 2018/18:37:45","MinExpectedNodeJSVersion":"8.9.3","ActNodeJSVersion":"8.15.1","ActNodeREDVersion":"0.19.6","selectedSignalPath":"input~receive_001~Sig_2","fieldbusObj":"4942edff.af1714","x":210,"y":200,"wires":[["1919240d.7515ac","94d2fcb9.f9209"]]},{"id":"383cd8e4.420da8","type":"debug","z":"37600b34.10de04","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":600,"y":180,"wires":[]},{"id":"1919240d.7515ac","type":"debug","z":"37600b34.10de04","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":610,"y":220,"wires":[]},{"id":"a17a38d6.235088","type":"fieldbus out","z":"37600b34.10de04","name":"Output1","FieldbusNodeVersion":"1.2.7","WrapperVersion":"1.2.7","WrapperCompileDate":"Jan 18 2018/18:37:45","MinExpectedNodeJSVersion":"8.9.3","ActNodeJSVersion":"8.15.1","ActNodeREDVersion":"0.19.6","selectedSignalPath":"output~send_001~Sig_1","fieldbusObj":"4942edff.af1714","x":640,"y":360,"wires":[]},{"id":"b7cb186c.04d978","type":"inject","z":"37600b34.10de04","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":220,"y":370,"wires":[["12a7d83c.690c18"]]},{"id":"94d2fcb9.f9209","type":"influxdb out","z":"37600b34.10de04","influxdb":"850291.a835fd7","name":"Write value","measurement":"myValue","precision":"","retentionPolicy":"","x":590,"y":260,"wires":[]},{"id":"9abe59b0.293fc8","type":"fieldbus in","z":"37600b34.10de04","name":"Input3","FieldbusNodeVersion":"1.2.7","WrapperVersion":"1.2.7","WrapperCompileDate":"Jan 18 2018/18:37:45","MinExpectedNodeJSVersion":"8.9.3","ActNodeJSVersion":"8.15.1","ActNodeREDVersion":"0.19.6","selectedSignalPath":"input~receive_001~Sig_3","fieldbusObj":"4942edff.af1714","x":210,"y":260,"wires":[["94d2fcb9.f9209"]]},{"id":"a0b08833.c086d8","type":"fieldbus in","z":"37600b34.10de04","name":"Input4","FieldbusNodeVersion":"1.2.7","WrapperVersion":"1.2.7","WrapperCompileDate":"Jan 18 2018/18:37:45","MinExpectedNodeJSVersion":"8.9.3","ActNodeJSVersion":"8.15.1","ActNodeREDVersion":"0.19.6","selectedSignalPath":"input~receive_001~Sig_4","fieldbusObj":"4942edff.af1714","x":210,"y":300,"wires":[["94d2fcb9.f9209"]]},{"id":"6b08e85.6efa118","type":"debug","z":"37600b34.10de04","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":666,"y":489,"wires":[]},{"id":"42ff1da.a7ccae4","type":"comment","z":"37600b34.10de04","name":"Read from database (return last 5 min)","info":"","x":226,"y":449,"wires":[]},{"id":"c4044e5c.fe7ba","type":"influxdb in","z":"37600b34.10de04","influxdb":"850291.a835fd7","name":"READ DATABASE","query":"SELECT value FROM myValue WHERE time > now() - 1h limit 1000;","rawOutput":false,"precision":"","retentionPolicy":"","x":406,"y":489,"wires":[["6b08e85.6efa118"]]},{"id":"d3ebd25a.c0f92","type":"inject","z":"37600b34.10de04","name":"trigger","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":130,"y":80,"wires":[["1e409434.770dfc"]]},{"id":"5b1ff301.93ae4c","type":"debug","z":"37600b34.10de04","name":"","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":670,"y":60,"wires":[]},{"id":"5c95c3a9.66b76c","type":"comment","z":"37600b34.10de04","name":"Create a database","info":"","x":150,"y":40,"wires":[]},{"id":"1e409434.770dfc","type":"influxdb in","z":"37600b34.10de04","influxdb":"850291.a835fd7","name":"CREATE DATABASE \"MyTest\"","query":"CREATE DATABASE MyTest","rawOutput":false,"precision":"","retentionPolicy":"","x":430,"y":80,"wires":[["5b1ff301.93ae4c"]]},{"id":"12a7d83c.690c18","type":"change","z":"37600b34.10de04","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"payload.value","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":420,"y":380,"wires":[["a17a38d6.235088"]]},{"id":"4942edff.af1714","type":"fieldbus interface","z":"","availableStackName":"EtherNet/IP Adapter (version 2.12, build 5 revision 0): cifX0","interfaceComponents":"{\"fwName\":\"EtherNet/IP Adapter\",\"boardName\":\"cifX0\",\"fwVersionMajor\":2,\"fwVersionMinor\":12,\"fwVersionBuild\":5,\"fwVersionRev\":0,\"prtName\":\"EtherNet/IP\",\"className\":\"Adapter\",\"prtClassNumber\":10,\"commClassNumber\":5,\"channelNumber\":2,\"deviceNumber\":7660120,\"serialNumber\":21989}","clearOutputsOnDeploy":false,"traceFilePath":"/root/.node-red/node-fieldbus.log","traceLevelWrapper":"wrapper","traceLevelNode":"node"},{"id":"850291.a835fd7","type":"influxdb","z":"","hostname":"192.168.0.5","port":"8086","protocol":"http","database":"MyTest","name":"","usetls":false,"tls":""}]
Thanks
BR
Madhumat