Using values from controls in string range filter

[Michael_Ubry]

Hi,
I have column where are dates stored as string like this 20212, 20213,20214,20215…..

Now I would like to have controls panel which consists of two dropdown menu FROM and TO, in which user would choose the range of dates which should be applied to data on Dashboard.

Analogically, image there would be column with alphabet A,B,C,D… and I would like user to have option to choose FROM and TO values based on this string column.

I know its possible to do it via query DSL with static values:

{
  "query": {
    "range": {
      "alphabet": {
        "gt": "A",
        "lt": "D"
      }
    }
  }
}

However, I need to use values from dynamic field of controls like this:

{
  "query": {
    "range": {
      "alphabet": {
        "gt": "value from controls field FROM",
        "lt": " value from controls field TO "
      }
    }
  }
}

Thank you

[Michael_Ubry]

@dosant Hi, any solution for this?

Is it even possible to use user input as variable for dashboard query?
What about string range (controls can do only this for numbers)?

Controls is limited vizualization unfortunetally.

Thank you for answers.