Support the ongoing development of Laravel.io →
Requests Database Eloquent
Last updated 2 years ago.
0

$users = Role::find($role->id)->user->list('id', 'username');

Don't forget that the list method will not return a query, so it has to be the last method called. For example if you want to order by username, you have to do it like this:

$users = Role::find($role->id)->user->orderBy('username')->list('id', 'username');

Last updated 9 years ago.
0

No did not work,

$users = Role::find($role->id)->user->list('id','role_id', 'firstname', 'lastname'); Results in Call to undefined method Illuminate\Database\Eloquent\Collection::list()

$users = Role::find($role->id)->user->orderBy('firstname', 'ASC')->list('id','role_id', 'firstname', 'lastname'); Results in Call to undefined method Illuminate\Database\Eloquent\Collection::orderBy()

Even tried it with this: $users = $role->find($role->id)->with(array('user' => function($query){ $query->select('id', 'role_id', 'firstname', 'lastname'); }))->get();

But that ends up with zero results and the query looks like: select id, role_id, firstname, lastname from users where users.role_id in ('5629bb40-ce93-11e4-8422-940c6d8249ed', '8a5145e8-d01c-11e4-ba4c-e8de2707a099')

Why must something so simple be so difficult?

This works doing it manually: $users = DB::table('users')->select('id','role_id', 'firstname', 'lastname') ->where(array('users.role_id' => $role->id)) ->orderBy('firstname', 'ASC') ->get();

But whats the point of the relationship if I have to code it manually since the point of the relationship is to get the related model data associated with the relationship definition.

Last updated 9 years ago.
0

Sign in to participate in this thread!

Eventy

Your banner here too?

Moderators

We'd like to thank these amazing companies for supporting us

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

© 2024 Laravel.io - All rights reserved.