elasticsearch request an element in an array

Question

I have a document indexed in my elastic search like:

{
   ...
   purchase:{
     zones: ["FR", "GB"]
     ...
   }
   ...
}

I use this kind of query to find for example document with puchase's zone to GB

{
    "query": {
        "filtered": {
            "query": {
                "match_all": {}
            },
            "filter": {
                "term": {
                    "purchase.zones": "GB"
                }
            }
        }
    }
}

But with it i get no results... I would like to perform a query like in php in_array("GB", purchase.zones).

Any help would be very helpful.

Siddardha Budige · Accepted Answer · 2014-08-04 13:13:23Z

1

If your "purchase" field is nested type then you have to use nested query to access the "zones".

{
    "nested" : {
        "path" : "obj1",
        "score_mode" : "avg",
        "query" : {
            "bool" : {
                "must" : [
                    {
                        "match" : {"obj1.name" : "blue"}
                    },
                    {
                        "range" : {"obj1.count" : {"gt" : 5}}
                    }
                ]
            }
        }
    }
}

http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/query-dsl-nested-query.html

answered Aug 4, 2014 at 13:13

Siddardha Budige

1,0151 gold badge8 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

elasticsearch request an element in an array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related