Forum Eager Load Constraints issue

pmcalabrese

8 years ago

Database Eloquent

Last updated 2 months ago.

spescina

8 years ago

Try moving the with sentence before the where one

Last updated 2 months ago.

jarektkaczyk

8 years ago

The only thing that could be wrong there is the order in this part:

$count = $query->count();
$formatted_date = $date->format('Y-m-d H:i:s');
$query->where('measurements.created_at','>=',$formatted_date);

for the where statement is applied after the count is fired, so your $count holds value ignoring that where. Just swap the two and it may get you the result you need.

Last updated 2 months ago.

Your banner here too?

pmcalabrese pmcalabrese Joined 12 Apr 2014

Moderators

driesvints Joined 16 Dec 2013
joedixon Joined 23 Jun 2014
tvbeek Joined 8 Jan 2018
tomhatzer Joined 28 Oct 2021

We'd like to thank these amazing companies for supporting us

Your logo here?

The Laravel portal for problem solving, knowledge sharing and community building.

Moderators

Laravel.io

Socials

The community