Querying with special character in Field key

InfluxDB 2 Dashboards
1

I have a measurement with alot of Field keys, No Tag keys.
One of the field keys is LD.IDEB of type float.
How can I query this?
I allready tried this with no succes.

select ““LD.IDEB”” from blankaart limit 10
ERR: error parsing query: found LD, expected FROM at line 1, char 10
select ‘LD.IDEB’ from blankaart limit 10
ERR: error parsing query: found ., expected identifier, string, number, bool at line 1, char 12
select “‘LD.IDEB’” from blankaart limit 10
ERR: error parsing query: found ., expected identifier, string, number, bool at line 1, char 13

Regards

2

It is possible that periods are not allowed in field key names. They are not mentioned among the special characters allowed in field key names here: InfluxDB line protocol reference | InfluxDB OSS 1.7 Documentation

You can try using a \ to escape the special character and see if that works.

3

I checked with a member of our team and I was mistaken, periods are allowed in the field key names. So perhaps escaping the character will work. Hope this helps!

-Sonia