Hi all,
For my Kibana dashboard I want to have 2 dropdowns (of type ES|QL control), one with the API’s and another one with the endpoint corresponding to the API selected in the first dropdown. So for example, if API == 1, the endpoint should have options A, B and C, but if the API == 2, the endpoint should have options D, E and F. I’ve tried to realise this by adding the following data view called api-endpiont-matching:
| API | Endpoint |
|---|---|
| 1 | A |
| 1 | B |
| 1 | C |
| 2 | D |
| 2 | E |
| 2 | F |
| 3 | G |
| 3 | H |
| 3 | I |
For the first dropdown I define the name as ?api and populate the values with this query:
FROM api-endpoint-matching
| STATS BY api
For the second dropdown I define the name as ?endpoint and populate the values with this query:
FROM api-endpoint-matching
| WHERE api == ?api
| STATS BY endpoint
The first dropdown works just fine. But the second one doesn’t change all when I change the first dropdown.
Do you have any suggestions on how to fix this? I should be able to reference the value of one dropdown in the query of another dropdown right?