last record data in database not the latest data

Question

I made table conversations and table messages, each conversation has many messages, and i want to show the latest message a conversation has, so i use this

$conversation->messages->last()->body

its return the last message in the record but not the latest,

this is my record

database record

the latest messages not the last record , when i insert new message its not in the last record but inserted at some random order, that make the last() not work properly,

but i want to access it through eloquent collections, and not make a new query — Blue Moon, Sep 08 '22 at 04:27
i cant use the latest its said `Method Illuminate\Database\Eloquent\Collection::latest does not exist.` — Blue Moon, Sep 08 '22 at 04:40
same error `Method Illuminate\Database\Eloquent\Collection::orderBy does not exist.` — Blue Moon, Sep 08 '22 at 04:44
Try this https://stackoverflow.com/questions/36755804/laravel-eloquent-relations-latest — Dhan, Sep 08 '22 at 04:51

score 2 · Accepted Answer · answered Sep 08 '22 at 05:28

You want to sort a collection and get its last element.

Either sort in ascending order and take the last element:

$conversation->messages->sortBy('created_at')->last()->body

Or sort in descending order and take the first element:

$conversation->messages->sortByDesc('created_at')->first()->body

Whichever you consider more readable.

score 0 · Answer 2 · answered Sep 08 '22 at 04:17

0

Attach timestamp column in your table and then select messages order by timestamp desc.

You will get last message.

answered Sep 08 '22 at 04:17

devil_sm

31
6

what do you mean by that ? i dont really understand – Blue Moon Sep 08 '22 at 04:22
i want to access it through eloquent collection so that i dont need to make a new query – Blue Moon Sep 08 '22 at 04:29

last record data in database not the latest data

2 Answers2