/    Sign up×
Bounties /Pin to ProfileBookmark

How can I filter only users that have relationship entries in Laravel?

to post a answer
Laravel

1 Replies

Copy linkTweet thisAlerts:
@JacobBarkerAug 11.2022 — By using has() or whereHas() on the user:
For example, if a user has many posts, you could achieve this by using the has method on the User model: $users = User::has('posts')->get(); There is one more way, by using whereHas, which also allows you to check for further filtering on the relationship, for example if we want users that have posts in 2021 or newer:
$users = User::whereHas('posts', function($q){
$q->where('created_at', '>=', '2021-01-01 00:00:00');
})->get();
×

Success!

Help @ReilyAcevedo spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 5.8,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...