I have a very frustrating scenario, where I want to get all results where type = 2. Upon viewing this query in the view, it's showing where type = 5
.
Eloquent function:
RequestModel::where('id', $object->pluck('id'))
->appointments()
->orderBy('created_at', 'asc')
->paginate('10');
Appointments scope:
public function scopeAppointments($query)
{
return $query->where('type', '=', 2);
}
Snippet of query outputted on view:
from `requests` where `id` = '4' and `type` = '5'
If I remove the ->appointments()
method, it removes the type = '5'
, so I know it's directly relating to it.
Even if I do not use a scope, and use a ->where('type', 2)
, it still returns 5
.
If I put the type query directly into the first section, it works as expected, for example:
RequestModel::where('type', 2)
->orderBy('created_at', 'asc')
->paginate('10');
Why doesn't a second where
query do as it's intended and why is it showing 5
, when I explicitly have chosen 2
!
from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2kHrf5F
via IFTTT
Aucun commentaire:
Enregistrer un commentaire