Eloquent query hasManyThrough in Laravel

Question

I have 3 models

Event - table('events')
Shift - table('shifts')
Workedtime - table('workedtimes')

and I can call event->shifts->workedtimes, all is fine there.

And now I want to make a query to get all Events where (Auth) user has worked.

Something like this:

Event::with('workedtimes')->where('workedtimes.uid', Auth::user()->id)->get();

But this doesn't work. What can I try next?

Alexey Mezenin · Accepted Answer · 2017-01-17 12:44:25Z

2

To get all events where authenticated user has worked you need to use whereHas() method:

$events = Event::whereHas('workedtimes', function($q) {
    $q->where('uid', auth()->user()->id);
})->get();

answered Jan 17, 2017 at 12:44

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

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

1 Comment

lewis4u Over a year ago

That's the one! Thank you!

Sanzeeb Aryal · Accepted Answer · 2017-01-17 12:40:13Z

0

You may be looking for Constraing eager loading. Query:

   Event::with(['workedtimes' => function ($query) {
        $query->where('uid', Auth::user()->id );
    }])->get();

answered Jan 17, 2017 at 12:40

Sanzeeb Aryal

3,2663 gold badges23 silver badges44 bronze badges

5 Comments

lewis4u Over a year ago

i copy pasted your answer and i got an error....then i copy pasted the answer from Alexey and it worked right away... :(

Sanzeeb Aryal Over a year ago

@lewis4u it's ok. but, it shouldnot give the error. what error you got?

lewis4u Over a year ago

I have tried again and actually it's not a functional error but instead of getting only the events where user worked i get ALL events...with your query i get 122 events and with Alexeys code i get 9

Sanzeeb Aryal Over a year ago

@lewis4u you got your answer, whereHas() is correct. btw this gives all the events and only the workedtimes of the authenticated user.

lewis4u Over a year ago

Ok i see. Well that was the problem. I wanted only events where user has worked. Problem solved. I hope it will help others too!

Collectives™ on Stack Overflow

Eloquent query hasManyThrough in Laravel

2 Answers 2

1 Comment

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related