CODEWITHSUNDEEP
phplaraveleloquenteloquent-relationshiplaravel-models
mahbub
mahbub

Reputation: 183

how to get unique data from database using eloquent model (laravel)

here is my code -

$list = Plot::active()
             ->whereNotNull('user_id')
             ->distinct('user_id')
             ->with('user')
             ->paginate(10);

but here "distinct('user_id')" not working. I want only unique user_id.

Upvotes: 1

Views: 48

Answers (1)

mahbub
mahbub

Reputation: 183

I solved the problem in this way -

$list = User::has('plots')->whereHas('plots', function ($query) {
            $query->active();
        })->with('plots')->paginate(10);

user - hasMany plots (one to many relationship)

plot - belongsTo user (many to one relationship)

Upvotes: 0

Related Questions