#relationship (1) #vps (5) #ssh (1) #command (1) #tricky (10) #cpanel (1) #docker (5) #eloquent (2) #excel (1) #testing (1) #en (22) #cron (1) #linux (8) #livewire (3) #laravel (13) #server (1) #session (1) #select2 (2) #devops (4) #git (1)

05-09-2022

Order by Relationship column, Solved it!

This was a thousand year old tricky question for me. But no more!

To order a query by a relationship column, you need a few things:

Use the following:

$posts = Post::query()
  ->withAggregate('user', 'name')
  ->orderBy('user_name')
  ->get();

What happens? Give the following:

->withAggregate('RELATIONSHIP', 'COLUMN')

So you can use the RELATIONSHIP_COLUMN as an addition to your original query.

Original inspiration: https://laravel-code.tips/use-the-withaggregate-method-to-add-related-values-to-eloquent-queries-using-subselects/


More posts
#relationship (1) #vps (5) #ssh (1) #command (1) #tricky (10) #cpanel (1) #docker (5) #eloquent (2) #excel (1) #testing (1) #en (22) #cron (1) #linux (8) #livewire (3) #laravel (13) #server (1) #session (1) #select2 (2) #devops (4) #git (1)
DLNA service on your server

This is how you setup DLNA service to your server!

#en #livewire #server
Increase swap size

Want to increase swap size on linux?

#en #linux
Login via SSH key only

Want to connect to server via SSH key only? Let's do it!

#en #linux
Twitter GitHub LinkedIn

© 2024 PappZ. All rights reserved.