Tag: eloquent-relationship

Access nested related objects with where clause in Laravel using Eloquent

eloquent eloquent-relationship laravel php

I’m trying to get a list of tasks that are associated with a specific client, but there is no direct relation between a task and a client. I also need to filter those tasks based on task status and …

Laravel HasMany WhereNotIn Query

eloquent eloquent-relationship laravel laravel-5 php

Problem: I’m trying to query a PeopleType to find all the courses where a person isn’t associated. I have 4 tables People PeopleTypes Courses People_Courses PeopleType_Courses I have the following …

Laravel one-to-many relationship with different column than primary key

eloquent eloquent-relationship laravel php

Eloquent: Get ‘max’ values from a `hasMany` -> `hasOne` relationship

eloquent eloquent-relationship laravel php

I have an interesting eloquent challenge and my knowledge is not quite there to work it through, hoping you smart folks can give me some guidance. I have read this: Getting just the latest value on a …

Pulling all categories and grouping them by parent id

eloquent eloquent-relationship laravel laravel-5.8 php

I am working with Laravel data querying and I need a query that is going to group all the children of a parent when I take the categories. the categories table has a name and a parent_id, the routes of the categories have the parent_id set as null, the query should return every category grouped by parent id and the