Pass multiple values(500 more ) in kibana dashboard

[jeff_arthur]

Hi,

How can i pass multiple values in kibana dashboard - 'add filter' - 'is one of' ? I have a txt file with 500 values ​​in it.

[afharo (Alejandro Fernandez Haro)]

Hi @jeff_arthur,

Unfortunately, Kibana currently does not support loading files to set filters. However, I think for your use case, you can create the filter using the advanced "Edit as Query DSL" option.

You can set a query like the one below:

{
  "query": {
    "terms": {
      "your_field": [
        "value1",
        "value2",
        ...
        "value500"
      ]
    }
  }
}

So you can copy-paste the values from your txt file.

For more info about the terms query: https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-terms-query.html

[jeff_arthur]

thanks for your answer. I think it is so hard copy-paste.hopefully elk this feature(loading files to set filters) will come.By the way, if my query finds any value of 500, we can use the following query to return a result. I customized it a little more.

{
  "query": {
    "bool": {
      "should": [
        {
          "match_phrase": {
            "Domain": "value1"
          }
        },
        {
          "match_phrase": {
            "Domain": "value2"
          }
        }
      ],
      "minimum_should_match": 1
    }
  }
}