You could try something like:
Sensor::with(['measurements' => function ($q)
{
$q->orderBy('measured_on', 'desc')->groupBy('sensor_id');
}])->get();
Let me know if that gets you close.
Last updated
1 year ago.
Good idea, but it does not work, since orderBy is performed on the already grouped rows with a measured_on value corresponding to the measurement that was first inserted into the db.
The ordering should have been performed before the grouping, but that is impossible I guess...
Last updated
1 year ago.
Sign in to participate in this thread!
Laravel
Laravel News
Laracasts
Laravel Podcast