Elasticsearch array of strings filter specific value

Hey everyone,
I am using Elasticsearch 5.2 with Kibana 5.2 and I am inserting my data correctly. The problem is that I have a field called "country_names" which represents a list of strings and when I want to query for a specific country within this list, the result shows me also the other strings (countries) in the same list. Any idea how to fix this issue? Thanks in advance.

Difficult to say exactly are you talking about Discovery, or Visualizations and how are you looking at the data. A screen shot of your current question might help

Of course I would recommend that you split the field to be a separate record but not sure your needs. The idea with elasticsearch would to have the data in the document the way you want to display it. but that is not always easy or possible

You could always look at script able fields and scripted aggregations
Try starting here
https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-script-query.html

https://www.elastic.co/guide/en/kibana/current/scripted-fields.html

Thanks for your reply and advice a lot. I have looked at the two links you suggested me and also to other links and I found out that the only way is to separate them like you suggested in the first place. Thanks again eperry.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.