Laravel 6 - Relation OrderBy another relation

Question

i have a project where i can access to company name like this:

$user->atc_results->first()->atc_company->name;

i'm tryng to order my results orderBy company_name but it doesn't work.

public function atc_results()
{
   return $this->hasMany('Modules\Atc\Entities\AtcResult')->with("atc_company")->orderBy("atc_company.name","asc");
}

can you help me ?

Does this answer your question? [Laravel Eloquent: How to order results of related models?](https://stackoverflow.com/questions/25700529/laravel-eloquent-how-to-order-results-of-related-models) — apokryfos, Dec 04 '20 at 14:31

score 1 · Answer 1 · answered Dec 04 '20 at 14:30

1

Try to use the closure within the array when calling with() to add further query elements to your atc_company relation:

public function atc_results()
{
   return $this->hasMany('Modules\Atc\Entities\AtcResult')
            ->with(['atc_company' => function($q) {
                $q->orderBy('name', 'desc');
            }]);
}

answered Dec 04 '20 at 14:30

Mouad ZIANI

132
1
8

did you replace desc with asc ? – Mouad ZIANI Dec 04 '20 at 14:45

score 0 · Answer 2 · answered Dec 04 '20 at 15:16

Probably going the other way around will work

class AtcCompany extends Model
{
    public function atcResults()
    {
        //Asumption that relation is belongsTo
        //Check the foreign key and owner key as per db
        return $this->belongsTo(AtcResult::class);
    }
}

//Somewhere in some controller method
function atc_companies()
{
    //$results will still contain data for both AtcResult & AtcCompany
    $results = AtcCompany::with('atcResults')->orderBy('name', 'asc')->get();
    
   
    return $results;
}

Laravel 6 - Relation OrderBy another relation

2 Answers2