Metadata field from item not showing up in InfluxDB2

Setup, Configuration and Use Beginners
, , ,
1

Hi everyone, im new here.

Im trying to create a simple extra field in one of my items by adding it as “metadata” via the UI entering it as a “namespace”, is this the correct way of doing it?

2024-10-211
2024-10-2111014×447 10.4 KB

The Item itself (being a motion sensor) is showing up with data in InfluxDB2 but now i decided i wanted to add an extra field in it such as “sensor_id” and adding it like i did in the above, does not show up in the fields or in any data under the motion sensor item in InfluxDB2 UI.

I restarted the server, i cleared Openhab cache, etc.. but still the metadata is not visible in InfluxDB2.

Am i missing an extra step here?

OpenHab 4.2.2
InfluxDB2

2

No — metadata won’t be added to InfluxDB.
See InfluxDB (0.9 and newer) - Persistence Services | openHAB.

3

As stated in the linked documentation, it will :slight_smile:

Number:Temperature tempLivingRoom (gTempSensors) { influxdb="temperature" [sensorId="111"] }
4

Oh, didn’t notice that part of the docs.

I can see that @s10 has entered the wrong namespace for the UI-based metadata.
The namespace needs to be influxdb.
Just have a look at the linked docs.

5

thanks, i changed it to influxDB2 and it picked it up, but it picked it up as a string. How can i change it into an integer or float number? because i want to be able to use 111 in the Y Axis. in the graph.

I tried changing it into 111 without the quotes:

value: SensorID
config:
  sensorId: 111

but then i cant pick it up in influxdb2 UI

6

I’m not sure it is possible to change the tag to number, as it’s meant to be a string…
Maybe you can change the datatype on the fly when accessing the data?

7

I can do it on the fly in the query on InfluxDB2 like this:

....
|> map(fn: (r) => ({ r with _value: float(v: r.sensorId) }))
....

But I just dont know how much strain this can potentially cause the server for each motion sensor, each time any of them is detected?
Is there no other way to create metadata of an item to a numerical value that is not interpreted as a string?
I also would not prefer to create an extra item for every motion sensor and use a bunch of rules to get this small task done.

8

Err… You should already have one Item per motion sensor. You don’t need other Items or additional rules.

9

Yes and i said those items i have are strings. So i want to add a numerical value as metadata. Again, as i said… i can convert it on the fly in influxdb2, but is this the only way to do it? What about potential strain on the server each time the query runs?

10

A motion sensor should be of type Switch, not String. Maybe a x-y problem?

11

Sorry i made a mistake. My motion sensors are of type Switch, but i need a metadata of type Number, because i want to display them all on ONE graph and have them labeled on the Y Axis, to do that i need to use them as a numerical value and map them to a label on Grafana.
Just like they do in this vid: https://www.youtube.com/watch?v=9AA86wQeY3U

12

Florian, is it or is not possible to create the namespace tag as a numerical value and not a string? For the purposes of using it in InfluxDB2 and Grafana.
If not, can you recommend another way to do this besides converting it on the fly within the influxdb2 query?

13

I don’t know, I have not used that functionality yet.