How to query relational data in laravel using eloquent

Question

I have Project Model each Project has Many Positions from Position Model and each positions has Many Employees in Employee Model

Now I want to query all employees id's of the particular project regardless their position,

How can I achieve this using eloquent?

I think your question is well described, but at stackoverflow you will need to have the code you tried to solve it with included and or some steps to reproduce your problem, your question is very abstract and for future reference you will need to include more :) — mrhn
– mrhn, Commented May 9, 2019 at 9:04

mrhn · Accepted Answer · 2019-05-09 08:59:33Z

1

Roughly you would do something similar to this, where you can use whereHas to create nested queries on relations.

$employeeIdsToFilter = [1,2,3];

$filteredProjects = Project::query()->
    whereHas('positions' , function ($query) use ($employeeIdsToFilter) {
        $query->whereHas('employees', function($query) use ($employeeIdsToFilter) {
            $query->whereIn('id', $employeeIdsToFilter);
        });
    })->get();

answered May 9, 2019 at 8:59

mrhn

19.1k6 gold badges31 silver badges48 bronze badges

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

Comments

Mehran · Accepted Answer · 2019-05-09 10:21:39Z

0

You can use the HasManyThough relation. Here is the Link

answered May 9, 2019 at 10:21

Mehran

1951 silver badge10 bronze badges

Collectives™ on Stack Overflow

How to query relational data in laravel using eloquent

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related