Eloquent Relationship with 2 other Models and orderBy?

Event::with(['states' => function ($query) {
    $query->orderBy('name');
}, 'tasks' => function ($query) {
    $query->orderBy('id');
}])->findOrFail($id);

Put orderBy on each of your relationships.

Event model;

    public function states()
    {
        return $this->hasMany(State::class)->orderBy('name','asc'); 
    }

    public function tasks()
    {
        return $this->hasMany(Task::class)->orderBy('id','asc'); 
    }

Just guessing at the models and relationships, hopefully you get the idea

Thnx snapey, this is one solution, but in this case every that order will be that way every time, i fetch the models through the parent one. I think mightylal way is more flexible. Thank you both.

Well just create a new relationship

public function states()
{
    return $this->hasMany(State::class); 
}

public function statesByName()
{
    return $this->hasMany(State::class)->orderBy('name','asc'); 
}

But when i call this: $event = Event::with(['states','tasks'])->findOrFail($id);

$event->states is filled automatically by the states() method from the event model, isn't it?

The statesByName() must be called explicit. Or am i wrong?

But when i call this: $event = Event::with(['states','tasks'])->findOrFail($id);

Nothing to stop you;

$event = Event::with(['statesByName','tasks'])->findOrFail($id);

Aaaaaahhhh, now I got it, though the values are the models / tables. Thnx snapey.

please can you show me in the docu where i can read more about :with() sometimes i am to stupid to find something there...