Laravel Eloquent get result where relation data is null

Question

I have two Models User and Owner with many to many relationship

I want to fetch only those users who don't have owner

how can I get using eloquent

i tried

$query = User::whereHas('userOwners', function ( $subquery ){
                $subquery->whereNull('owner_id');                            
            })->get();

but not working.

@onlineThomas This is project management website where user(type1) assign project to user(type2) for followup.each user(type2) must have project, so need to find user who don't have any project. (Project is nothing its information of actual project owner(owners contact info for followup), ) — Sharad Kale
– Sharad Kale, Commented Sep 14, 2020 at 18:29

thefallen · Accepted Answer · 2017-08-03 13:03:39Z

41

Eloquent has a way to query an absent relationships, it should work like this in your case:

$query = User::doesntHave('userOwners')->get();

answered Aug 3, 2017 at 13:03

thefallen

9,8202 gold badges39 silver badges51 bronze badges

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

1 Comment

Sharad Kale Over a year ago

Its Worked. Thank you very much!

saber tabatabaee yazdi · Accepted Answer · 2020-09-14 15:39:00Z

0

 User::with('userOwners')
        ->whereHas('userOwners', function ($query) {
            $query->wherehas('owner_id');
        })
        ->where('user_status', 1)->get();

use second where if you want to filter on user

use first where if you want to filter on Owner

answered Sep 14, 2020 at 15:39

saber tabatabaee yazdi

4,9953 gold badges53 silver badges63 bronze badges

Comments

AddWeb Solution Pvt Ltd · Accepted Answer · 2017-08-03 12:55:47Z

-4

I think you should just change your query like:

$query = User::whereHas('userOwners')->get();

Hope this work for you!!!

answered Aug 3, 2017 at 12:55

AddWeb Solution Pvt Ltd

21.8k5 gold badges30 silver badges61 bronze badges

3 Comments

Luis Deras Over a year ago

He's asking for the opposite, users that do not have owners

Sharad Kale Over a year ago

This returning users with owner but I want without owners

AddWeb Solution Pvt Ltd Over a year ago

@SharadKale Ok let me check

Collectives™ on Stack Overflow

Laravel Eloquent get result where relation data is null

3 Answers 3

1 Comment

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related