Fetch data nested relations eloquent with() in Laravel

Question

I have a model file "Student" that contains the relation :

 public function implementations()
 {
       return $this->hasMany(Implementation::class);
  }

In my Implementation model, I have theses relations :

public function score()
    {
        return $this->belongsTo(Score::class, 'id', 'implementation_id');
    }

public function project()
    {
        return $this->belongsTo(Project::class);
    }

I would like to retrieve a table with all its data.

I tried this

public function getStudents($id)
{
    $event = Event::where('id', $id)->first();
    $data = $event->students()->with('implementations')->get();

    return response()->json($data);
}

It works. But I do not have the result I would like. I would also like to recover the implementations data with theproject and score relationships

I tried that but it does not work

public function getStudents($id)
{
    $event = Event::where('id', $id)->first();
    $data = $event->students()->with('implementations')->with('project', 'score')->get();

    return response()->json($data);
}

Thank you very much for your help!

Have you tried Event::with('students', 'students.implementations') yet? You can eager load relations of relations using the dot notation. — N Mahurin
– N Mahurin, Commented Jan 21, 2019 at 18:54
It's work ! $data = $event->students()->with('implementations', 'implementations.project', 'implementations.score')->get(); Thank you ! — Jeremy
– Jeremy, Commented Jan 21, 2019 at 18:58

N Mahurin · Accepted Answer · 2019-01-21 19:08:50Z

3

Have you tried Event::with('students', 'students.implementations') yet? You can eager load relations of relations using the dot notation.

answered Jan 21, 2019 at 19:08

N Mahurin

1,45611 silver badges18 bronze badges

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

1 Comment

Rizwan Saleem Over a year ago

I use this relation and I am unable to use eager load relation value inside the relation $sql->with(['postable' => function($sql) use($is_detail) { if ($is_detail && in_array(config('general.post_type_index.search'), ["postable.post_type_id"])) { $sql->with(["postable"]); } }]);

Collectives™ on Stack Overflow

Fetch data nested relations eloquent with() in Laravel

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related