for our service we need an nested query. The problem is that iam not so familiar with elasticsearch language and i can only explain my needs in SQL language.
SELECT * FROM index WHERE attribute IN (SELECT attribute FROM index WHERE key = X)
Is there a chance to realize that in elasticsearch and visualize it in kibana?
Maybe i can do the same with an visualization and a control panel in Kibana -- The first visualization is the outter SELECT and the control panel is the inner SELECT. I have done that already with one problem. In the option panel was more than 400 values and there is no select all option.
I look forward to your answers