1

Like filters are available for query results and visualizations for SQL queries. E-G : SELECT action AS “action::filter”, COUNT (0) AS “actions count”
FROM events
GROUP BY action

Can you please let me know, whether the same is possible using elastic search query or not ?

2

If ElasticSearch queries support renaming output fields, then you can use filters by renaming the fields to have the ::filter or __filter suffix.

3

Hello Arik, can you please elaborate. Our scenario is,

{
“index”: “game_code”,
“aggs”: {
“Name”: {
“terms”: {
“field”: “player_name”
},

        "aggs": {
    "Country": {  "filter" : {
           
              "bool" : {
  "should" : {
    "term" : { "Country" : "{{Select the country name}}"}} }
  },
        "aggs": {
            "Team": {
                "terms": {
                    "field": "team_name"
                }
        
    
}
        }}}
        }
    }
}

When this code is executed, according to country name we type in the text box, the player names and their team names will be displayed.
The output is

1198×229 19.1 KB

In this execution, in the textbox, the country name must be manually typed.
But our desired output is , the country names must be displayed as dropdown list rather than manual typing. Like this
1066×614 23.8 KB

Can you guide us wherein the change must be made in code, so as the receive the desired output ?

4

Arik, we are waiting for your reply, it’s quite urgent.

5

You need to rename the fields in the output to include the __filter or __multiFilter suffix. There are different ways to achieve this depends on your Elastic Search version and configuration.

6

Hi,
I have a similar requirement. I couldn’t find something like this in elasticsearch .
Can you please point me to some resources where I can get some hint how to achieve this.