Level 102
Use a left join instead :)
Feb 10, 2023
5
Level 1
orderBy a whereHas column without ignoring the unrelated data?
I have got users table related to a roles table "many to many relationship"; users are related to the roles and I want to order them by the role name so I built this query
User::whereHas('roles', function($query) {
return $query->orderBy('name');
});
it does what I want.. but if some users are not related to any roles they are not fetched.. I want to fetch them too but list them at the end of the records maybe.. How can I do that?
Level 1
@Sinnbeck this will lead me to refactor lots of changes. I'm trying to build a trait to be reused for many models so isn't there any other way to do it without joins?
Level 102
@sh1r3f but under the hood whereHas is just where exists in sql. So I don't see how you expect that to work? Is it because you want to use relationships? https://packagist.org/packages/kirschbaum-development/eloquent-power-joins
Level 1
Solved by this solution https://stackoverflow.com/a/72667602/20556973
Level 102
@sh1r3f yeah a sub query works as well
Please or to participate in this conversation.