[Solved] How to query in kibana for a column name having space in it

Hello all,

In my documents I have a column with space in it.
e.g. current city.

How can I create a query in kibana discover tab which will access this field in my data.
I tried the following and nothing seems to be working

  1. current city:Bangalore
  2. [current city:Bangalore]
  3. "current city":Bangalore
  4. 'current city':Bangalore

Please direct me towards the correct way to do this.

It seems like we will have to escape space with a backslash for usage.
This is wierd as business users may feel bit uncomfortable with the same.

soln

current\ city:Bangalore

this did the trick.
Please suggest if there is a better way of doing so,

1 Like