Laravel 5 scope not working

Question

I have the following scope:

public function scopeLabel($query, $label)
{
    return $query->with(['label' => function ($q) use ($label) {
        $q->where('name', '=', $label)->get();
    }]);
}

Which I then use as follows:

$appointments = Appointment::latest('created_at')->label($label)->get();

The $label is fetched from a POST form and it matches the name field of my labels table.

The above query works when I call it directly from the controller, like so:

    Appointment::with(['label' => function ($q) use ($label) {
        $q->where('name', '=', $label)->get();
    }])->get();

This then returns all results from my Appointments table, where the appointments.label_id matches the labels.id in the Labels table. I hope you're still with me :)

But when I use the query in a scope, like the above, it doesn't work. It simply returns all results, and I cannot seem to figure out why this is. Any pointers?

Yes, never mind this, my query isn't working either if I put it directly in the controller. I will probably have to use whereHas or something. I will figure it out and post an answer :) — Hardist
– Hardist, Commented Jan 27, 2016 at 17:22

Community · Accepted Answer · 2017-05-23 12:01:43Z

1

Answered already once, similar issue I had, and I didn't learn anything from it, shame on me.

Laravel Search Relationship

        $appointment = App\Appointment::whereHas('label', function ($query) use ($label){
            $query->where('name', '=', $label);
        })
            ->with(['status' => function($query) use ($label){
                $query->where('name', '=', $label);
            }])->get();

edited May 23, 2017 at 12:01

CommunityBot

11 silver badge

answered Jan 27, 2016 at 17:25

Hardist

2,01111 gold badges53 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Laravel 5 scope not working

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related