Level 7
You could add the id of the School to your students table? Then create another relationship.
Dec 7, 2017
7
Level 1
Eloquent API resources - nested relationship?
Hi,
Well, in resource (School) I've tried to load nested relationship something like this: 'students' => UserResource::collection($this->whenLoaded('classes.user')) but without success.
In controller I have something like this:
SchoolResource::collection(School::with(['classes.user'])->get());
School has many classes. Class can have many students. One student can be only in one class. I wish to return all students that are in particular school.
Is this possible using Eloquent API resource or do I need to make custom response?
Level 1
That won't work for this case as one student can be in one class in one school. But can also be another class in another school which means that student can be in multiple schools so adding school_id won't work.
But thank you for your suggestion.
I was just wondering will whenLoaded method work with nested relationship. As I could see from the code of whenLoaded function, it only accept one relationship as string.
Level 1
@Mrtvac if there is an many to many relationship with students and school you should define that and let laravel create a pivot table.
After that you can load the relationships of both. I think.
https://laravel.com/docs/5.5/eloquent-relationships#polymorphic-relations.
Don't know if this is what you meant.
Level 2
@Mrtvac did you solve this problem? Can share your solution here? Thanks
Level 1
Hi @integrasolid This project was long time ago and I don't work on it anymore so I'm not sure to be honest, but as I could remember, I've used different approach/logic to solve this problem. As I could remember, this nested relationship in resource didn't work at that point.
Level 2
@Mrtvac thanks, looks like for now I will settle with not checking whenLoaded for nested relationship
Level 9
Yes, it's seems that whenLoaded method doesn't check nested relationships. I solved that in this way
...
'parentRelation' => $this->whenLoaded('parentRelation', function () {
return [
'id' => $this->parentRelation->id,
'title' => $this->when(
$this->parentRelation->relationLoaded('childRelation'),
fn () => $this->parentRelation>childRelation->title
)
];
}),
...
Please or to participate in this conversation.