Eager Loading multiple relationships with a filter on a relation with Eloquent ORM

Question

I have the following code that doesn't work:

$threads = MessageThread::with('last_message', 'thread_visibility')
    ->where('message_thread_visibility.user_id', Auth::user()->id)->get();

What is the best way to add a "where" clause to an eagerly loaded multiple relationship eloquent query in Laravel?

eski009 · Accepted Answer · 2013-06-25 13:37:09Z

6

$threads = MessageThread::with(array(
     'last_message', 
     'thread_visibility' => function($query) { 
            $query->where('user_id', 2); 
      }))->get();

The above seems to work.

answered Jun 25, 2013 at 13:37

eski009

3711 gold badge7 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

Eager Loading multiple relationships with a filter on a relation with Eloquent ORM

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related