Node-Red - querie "influxdb.errors.noquery"

1

Hi,

I have a flow in node red that need to query my BD “gps”, it returns “influxdb.errors.noquery”, but if I take the same query in put it in the cli I get the expected result.

select * from gps where tag2 = ‘lora_1’ ORDER BY time ASC

image
image920×161 65.5 KB

image

[{"id":"6ed45495.d6025c","type":"ui_button","z":"9f01b80.4b68948","name":"","group":"fe8b6129.f0b8d","order":1,"width":0,"height":0,"passthru":false,"label":"Get GPS Tracks","tooltip":"","color":"","bgcolor":"","icon":"","payload":"","payloadType":"str","topic":"","x":160,"y":480,"wires":[["be768ca1.dd9af","56469b53.76b4c4","9f19ef6a.a750a","fbfa9714.2f3578"]]},{"id":"ff8bf2f4.e5ba5","type":"influxdb in","z":"9f01b80.4b68948","influxdb":"6de8a9.738f5758","name":"gps","query":"","rawOutput":false,"precision":"","retentionPolicy":"","org":"","x":630,"y":480,"wires":[["113301cf.7ff37e","2ad436b1.f133aa","d695df9.790192","39b66c47.2a1c34","a9c62700.c6b548"]]},{"id":"be768ca1.dd9af","type":"function","z":"9f01b80.4b68948","name":"GPS port 1","func":"var devName = flow.get(\"deviceName\");\nmsg.payload = \"select * from gps where tag2 = '\"+ devName +\"' ORDER BY time ASC\";\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":370,"y":480,"wires":[["ff8bf2f4.e5ba5","bc65d3f9.94731","6f710d6c.a60594"]]},{"id":"fe8b6129.f0b8d","type":"ui_group","name":"GPS","tab":"f95c78be.033988","order":2,"disp":true,"width":"6","collapse":false},{"id":"6de8a9.738f5758","type":"influxdb","hostname":"127.0.0.1","port":"8086","protocol":"http","database":"gps","name":"","usetls":false,"tls":"","influxdbVersion":"1.x"},{"id":"f95c78be.033988","type":"ui_tab","name":"GPS","icon":"dashboard","order":3,"disabled":false,"hidden":false}]
2

The notes stae the msg.query need to be the query you want to run, I made the both msg.payload and the msg.query equal to the query and it’s working - 'select * from gps where tag2 = ‘lora_1’ ORDER BY time ASC"