How to query multiple parameters in a nested field in elasticsearch

Question

I'm trying to search for keyword and then add nested queries for amenities which is a nested field of an array of objects.

With the query below I am able to search when I'm only matching one amenity id but when I have more than one it doesn't return anything.

Anyone have an idea what is wrong with my query ?

{
  "sort": [
    {
      "_score": {
        "order": "desc"
      }
    },
    {
      "_geo_distance": {
        "geolocation": [
          100,
          10
        ],
        "order": "asc",
        "unit": "m",
        "mode": "min",
        "distance_type": "sloppy_arc"
      }
    }
  ],
  "query": {
    "bool": {
      "must": [
        {
          "multi_match": {
            "fields": [
              "name^2",
              "city",
              "state",
              "zip"
            ],
            "fuzziness": 5,
            "query": "complete"
          }
        },
        {
          "nested": {
            "path": "amenities",
            "query": {
              "bool": {
                "must": [
                  {
                    "term": {
                      "amenities.id": "1"
                    }
                  },
                  {
                    "term": {
                      "amenities.id": "2"
                    }
                  }
                ]
              }
            }
          }
        }
      ]
    }
  }
}

Can you show a document sample which suppose to match this query? — Tomer Arazy
– Tomer Arazy, Commented Jul 2, 2017 at 15:50

Tomer Arazy · Accepted Answer · 2017-07-02 15:49:39Z

1

When you do:

"must": [
  {
    "term": {
      "amenities.id": "1"
    }
  },
  {
    "term": {
      "amenities.id": "2"
    }
  }]

What you're actually saying is find me any document where "amenities.id"="1" and "amenities.id"="2" which unless "amenities.id" is a list of values it won't work. What you probably want to say is find me any document where "amenities.id"="1" or "amenities.id"="2" To do that you should use should instead of must:

"should": [
      {
        "term": {
          "amenities.id": "1"
        }
      },
      {
        "term": {
          "amenities.id": "2"
        }
      }]

answered Jul 2, 2017 at 15:49

Tomer Arazy

1,82311 silver badges15 bronze badges

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

2 Comments

user3791980 Over a year ago

Amenities is an array of objects, so I'm trying to match records than contain both of the amenities. Is this possible ? or do I need to restructure my data ?

Tomer Arazy Over a year ago

Can you give an example of such document?

Collectives™ on Stack Overflow

How to query multiple parameters in a nested field in elasticsearch

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related