Get latest records ordered by date?

@kaju74 ModelName::latest('column_name')->get();

Hi,

thank you for the quick answer, but this only calls a simple "$this->orderBy($column, 'desc')" and doesn't return the latest row of EACH week...

Marc

Okay, it seems, I found a solution:

        $publications = $query
            ->where('user_id', $user->id)
            ->where('start_at', '>=', Date::now()->startOfWeek())
            ->orderBy('start_at', 'asc')
            ->orderBy('created_at', 'desc')
            ->get()
            ->groupBy(function ($item) {
                return substr($val = $item['start_at'], 0, strpos($val, ' '));
            })
            ->pluck(0);

...but, is there's a smarter way to do this? Marc

@kaju74 The solution you posted will load all the results and group inside the php function, will work but not very elegant if you have many rows to return.

Another solution involves using group by inside the sql query. You will have to create subtable using aggregate functions and group by, join it, to original table and then select from them.

...that's what I've tryed but I can't figured out the correct syntax...8-(

Regards, Marc

you need to do this query:

SELECT t1.* FROM table as t1 WHERE (t1.start_at, t1.created_at) IN (SELECT t2.start_at, MAX(t2.created_at) FROM table as t2 GROUP BY t2.start_at);

(you need an index on start_at/created_at)

just use DB::select(), or somebody with more knowledge can say how to use the subquery with eloquent / query builder.

thanks. I'll try that out asap