[FIXED] How to get the last Elasticsearch document for each unique value of a field?

Issue

I have a data structure in Elasticsearch that looks like:

{
  "name": "abc",
  "date": "2022-10-08T21:30:40.000Z",
  "rank": 3
}

I want to get, for each unique name, the rank of the document (or the whole document) with the most recent date.

I currently have this:

"aggs": {
  "group-by-name": {
    "terms": {
      "field": "name"
    },
    "aggs": {
      "max-date": {
        "max": {
          "field": "date"
        }
      }
    }
  }
}

How can I get the rank (or the whole document) for each result, and if possible, in 1 request ?

Solution

You can use below options

1. Collapse

"collapse": {
    "field": "name"         
  },
  "sort": [
    {
      "date": { 
        "order": "desc"
      }
    }
  ]

2. Top hits aggregation

{
  "aggs": {
    "group-by-name": {
      "terms": {
        "field": "name",
        "size": 100
      },
      "aggs": {
        "top_doc": {
          "top_hits": {
            "sort": [
              {
                "date": {
                  "order": "desc"
                }
              }
            ],            
            "size": 1
          }
        }
      }
    }
  }
}

Answered By - jaspreet chahal

Answer Checked By - Katrina (PHPFixing Volunteer)