Elasticsearch query identical arrays

Question

I have documents like these:

Doc1

{
"id": ...,
...
"articles": [
  {
    "id": "5cdd17c7e24f6e05d487b2c2#142936",
    ...
  },
  {
    "id": "5cdd17c7e24f6e05d487b2c2#226536",
    ...
  }
...
}

Doc2

{
"id": ...,
...
"articles": [
  {
    "id": "5cdd17c7e24f6e05d487b2c2#142936",
    ...
  },
  {
    "id": "5cdd17c7e24f6e05d487b2c2#226536",
    ...
  },
  {
    "id": "5cdd17c7e24f6e05d487b2c2#142965",
    ...
  }
...
}

Doc3

{
"id": ...,
...
"articles": [
  {
    "id": "5cdd17c7e24f6e05d487b2c2#142936",
    ...
  }
...
}

And I want the document exactly has the array of articles I need. For example, if my Array of article Ids is ['5cdd17c7e24f6e05d487b2c2#142936', '5cdd17c7e24f6e05d487b2c2#226536'] I only want to get the Doc1.

Now I have this query:

GET my_index/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "nested": {
            "path": "articles",
            "query": {
              "query_string": {
                "default_field": "articles.id",
                "query": "5cdd17c7e24f6e05d487b2c2#142936 AND 5cdd17c7e24f6e05d487b2c2#226536"
              }
            }
          }
        }
      ]
    }
  }
}

But with this, I get Doc1 & Doc2...

avik · Accepted Answer · 2020-08-01 15:14:06Z

1

Assuming articles.id is of type keyword, I think this should work for you (not sure it's the most efficient way to write the query):

GET my_index/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "nested": {
            "path": "articles",
            "query": {
              "term": {
                "articles.id": "5cdd17c7e24f6e05d487b2c2#142936"
              }
            }
          }
        },
        {
          "nested": {
            "path": "articles",
            "query": {
              "term": {
                "articles.id": "5cdd17c7e24f6e05d487b2c2#226536"
              }
            }
          }
        }
      ],
      "must_not": {
        "nested": {
          "path": "articles",
          "query": {
            "query_string": {
              "default_field": "articles.id",
              "query": "NOT 5cdd17c7e24f6e05d487b2c2#142936 AND NOT 5cdd17c7e24f6e05d487b2c2#226536"
            }
          }
        }
      }
    }
  }
}

answered Aug 1, 2020 at 15:14

avik

2,70819 silver badges20 bronze badges

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

1 Comment

Doasy Over a year ago

Perfect!! Thank you!

Collectives™ on Stack Overflow

Elasticsearch query identical arrays

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related