Hello, I use InfluxDB 2.6 to visualize temperatures and humidity from my home with Grafana. Today I decided to rename an openHAB item and want to move the older measurements to the new item. I found in the forum some examples and have done the following:
from(bucket: "openHAB") |> range(start: 2022-12-01T00:00:00Z, stop: 2023-01-31T00:00:00Z) |> filter(fn: (r) => r["item"] == "ga_aussen_netatmo_messwert_temperatur") |> set(key: "item", value: "ga_aussen_netatmo_aussenmodul_messwert_temperatur") |> to(bucket: "openHAB")
Then I switched the filter in Grafana and saw for the new “ga_aussen_netatmo_aussenmodul_messwert_temperatur” the old data. After this I wanted to delete the old “ga_aussen_netatmo_messwert_temperatur” on the command line with:
influx delete -o SmartHome -b openHAB --start 2022-12-01T00:00:00Z --stop 2023-01-31T00:00:00Z -t "secret" -p "item=ga_aussen_netatmo_messwert_temperatur"
But the item is still there and when I select this on the UI, it seems that the new measurement is linked to the old item:
How can I delete the old item entry correct and what was my mistake when moving the data? I had to do this with other netatmo measurements, too. Thanks.