How to use msg.payload in INFLUXDB V2.4 query

General
1

Hello,
How to introduce the msg.payload variable in an influxDB V2.4 query. I want to put it in range(start: ).
</
msg.query=['from(bucket: "Temp")',
' |> range(start:"msg.payload")',
' |> filter(fn: (r) => r["_measurement"] == "Temperature 1")',
].join('\n');
return message;
/>

2

You can use a Template node (not ui_template) to create the query with the payload value embedded.

[Edit] Note that the query does not need to be on multiple lines, it can all be in one simple string.

3

Thank you Colin,
Have you an exemple please.

4

An example of what?
Did you read the help text for the Template node?

5

here is how i made the query, what i want is to use msg.payload as variable.

[{"id":"f77dfd0998d3cc46","type":"function","z":"1abeef9a268f3612","name":"","func":"//var var01=msg.payload;\nmsg.query='from(bucket: \"Temp\") |> range(start:-5h) |> filter(fn: (r) => r[\"_measurement\"] == \"Temperature 1\")';\n\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":260,"y":120,"wires":[["652b68907d4f05fb","a6332a1590c698ff"]]}]
6

It is much easier using a Template node as I suggested.

7

Thank you i try it

8

Just for completeness, if you ever do need to do stuff like this in a function node then the neatest way is to use the template literal syntax. So something like

msg.query = `from(bucket: "Temp") |> range(start:${msg.payload}) |> filter(fn: (r) => r["_measurement"] == "Temperature 1")`
return msg;
9

I tried that and it works.

var var01=msg.payload;
msg.query='from(bucket: "Temp")'+
' |> range(start:-'+var01+')'+
' |> filter(fn: (r) => r["_measurement"] == "Temperature 1")';

return msg;

Thank you for help

10

That is not what I suggested, and it would have been even easier in a Template node containing:
from(bucket: "Temp") |> range(start: {{payload}}) |> filter(fn: (r) => r["_measurement"] == "Temperature 1")
That is exactly what the Template node is for.

11

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.