FilamentF
Filament•2y ago
ericmp

Eloquent orWhere question

$oneDayAgo = now()->subDay();
$twoDaysAgo = now()->subDays(2);
$threeDaysAgo = now()->subDays(3);

is this part of an eloquent query
->where(function ($q) use ($oneDayAgo, $twoDaysAgo, $threeDaysAgo) {
    $q->orWhereDate('created_at', $oneDayAgo);
    $q->orWhereDate('created_at', $twoDaysAgo);
    $q->orWhereDate('created_at', $threeDaysAgo);
})

the same as this?
->where(function ($q) use ($oneDayAgo, $twoDaysAgo, $threeDaysAgo) {
    $q->whereDate('created_at', $oneDayAgo);
    $q->orWhereDate('created_at', $twoDaysAgo);
    $q->orWhereDate('created_at', $threeDaysAgo);
})

the difference is on the first orWhereDate/orWhere
the objective is to retrieve the records that their creation date is 1 day ago or 2 or 3 days ago
so all of them are OR but one of them must be true

i've searched it and i understand they are the same, but im not confident it is. what u'd say?
Was this page helpful?