How to groupBy relationship's column with descending order

[myckhel]

Given the example below
the latest order has no effect on the query
its grouped by the first item instead of the last item in the table

function events(){
  return $this->hasMany(ChatEvent::class, 'made_id')
  ->where('made_type', 'App\\Models\\Conversation')
  ->groupBy('type')->latest();
}

id	type	created_at
1	deliver	2020-12-27 12:11:05
2	deliver	2020-12-28 12:11:05
3	deliver	2021-01-05 09:17:20

sql output

select * from `chat_events` where `made_type` = ? group by `type` order by `created_at` desc

actual result

"chat_events": {
      "deliver": {
          "id": 1,
          "type": "deliver",
          "created_at": "2020-12-27T12:11:05.000000Z"
      },
  },

expected result

"chat_events": {
      "deliver": {
          "id": 3,
          "type": "deliver",
          "created_at": "2021-01-05T09:17:20.000000Z"
      },
  },

Please how can i make it retrieve expected result? @taylorotwell @themsaid @driesvints @lucasmichot

[lucasmichot]

https://stackoverflow.com/questions/31857961/order-by-before-group-by-using-eloquent-laravel

[myckhel]

Weeeew.
thanks but seems difficult todo with relationship.

i wonder why sql grouping so complicated.

[driesvints]

Please don't mass mention people. Someone will help you when they see this.

[myckhel]

Okay
cool.