Query documents that contains all values in nested array Elasticsearch

Question

I'm trying to query documents where the nested array contains all of the elements passed in the query.

The index stores groups and each group has a list of members. I want to query all the groups that contains the given members.

Mapping:

"properties" : {
   "members" : {
      "type" : "nested",
      "properties" : {
         "name" : {
            "type" : "keyword"
         }
       }
    },
    "name" : {
        "type" : "text"
     }
   }
  }
}

Example content:

[
  {
    "name" : "group 1",
    "members" : [
      {
        "name" : "alice"
      },
      {
        "name" : "bob"
      }
    ]
  },
  {
    "name" : "group 2",
    "members" : [
      {
        "name" : "alice"
      },
      {
        "name" : "foo"
      },
      {
        "name" : "bob"
      }
    ]
  },
  {
    "name" : "group 3",
    "members" : [
      {
        "name" : "foo"
      },
      {
        "name" : "bar"
      }
    ]
  }
]

How can I find all groups that have both "alice" and "foo" as members?

I have tried the following query but it returns nothing:

GET /group/_search
{
  "query": {
    "nested": {
      "path": "members",
      "query": {
        "bool": {
          "must": [
            {"match": {"members.name": "alice"}},
            {"match": {"members.name": "foo"}}
          ]
        }
      }
    }
  }
}

I have also tried with term instead of match but it gives no results.

Nivaldo Neto · Accepted Answer · 2019-08-05 20:25:56Z

3

You can use the nested within a must clause. Like this:

GET /group/_search
{
 "query": {
   "bool": {
     "must": [
       {
         "nested": {
           "path": "members",
           "query": {
             "term": {
               "members.name": {
                 "value": "alice"
               }
             }
           }
         }
       },
       {
         "nested": {
           "path": "members",
           "query": {
             "term": {
               "members.name": {
                 "value": "foo"
               }
             }
           }
         }
       }
     ]
   }
 }
}

answered Aug 5, 2019 at 20:25

Nivaldo Neto

1238 bronze badges

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

Collectives™ on Stack Overflow

Query documents that contains all values in nested array Elasticsearch

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