Elasticsearch query to filter docs based on some fields value and length of nested field

Question

I need to filter elasticsearch documents based on some fields value and a filter on the length of the nested field.

For Example:

{
  "id": 1,
  "source": "upi",
  "users": [
    {
      "name": "akshay",
      "mobile": "xxxx"
    }
  ]
}
{
  "id": 2,
  "source": "wallet",
  "users": [
    {
      "name": "Akshay",
      "mobile": "xxxx"
    }
    {
      "name": "Ajay",
      "mobile": "xxxx"
    }
  ]
}

Filter on source and length of users list like the source is "wallet" and length of users is 2 then should return document with id 2.

question from:https://stackoverflow.com/questions/65869721/elasticsearch-query-to-filter-docs-based-on-some-fields-value-and-length-of-nest

Answer 1

Waitting for answers