Is it possible to sort by Relation in Eloquent?

Question

Laravel

There is an entity that pulls other entities: User::with('withdrawals.withdrawalitems')->get(); Is it possible to use eloquenta methods (without losing access to models) to sort (or manipulate) by withdrawalItems?

Answer 1

Yes. whereHas.

Answer 2

Sorting by relation field only via manual JOIN, since with is performed by a separate query.
Something like:

$query = Post::join('categories', 'categories.id','=','products.category_id');
$query = $query->select('categories.name as cat_name','products.*');
$query = $query->orderBy('cat_name','asc');
$records = $query->get();

Answer 3

Pagination won't work for relationships. Only for the main entity, in your case for User.
And for sorting

User::with(['withdrawals' => function($query) {
    $query->select('id', 'name')->orderBy('created_at')->with(['withdrawalitems' => function($query) {
        $query->select('id', 'name')->orderByDesc('created_at')
    }])
}])->get();