Categories: Development

Setting the order by column for a Laravel model

How to set a Laravel model’s default orderby column without modifying existing queries or implementing in new calls.

This is done using the boot function which is used to override default actions in the model.

Here addGlobalScope is stated to modify any query for the model which will now order by created_at DESC

Effectively saving you from manually adding this orderby onto all the queries you will be using.

protected static function boot()
{
    parent::boot();

    static::addGlobalScope('order', function (Builder $builder) {
        $builder->orderBy('created_at', 'DESC');
    });

}

You will need to ensure the Builder trait is included at the top of page:

use Illuminate\Database\Eloquent\Builder;

 

Share

Recent Posts

Kennington reservoir drained drone images

A drained and empty Kennington reservoir images from a drone in early July 2024. The…

2 years ago

Merrimu Reservoir drone images

Merrimu Reservoir from drone. Click images to view larger.

2 years ago

Early September spring shots

Some early September spring shots from a bushwalk, It is still too early for wildflowers.

3 years ago

Cloning an NVMe to SK Hynix Platinum P41 NVMe

I recently needed to clone over a smaller NVMe to a 2TB SK Hynix Platinum…

3 years ago

Using Laravel’s deleteDirectory to delete folders and their contents

If you ever needed a simple solution in Laravel to delete an entire directory and…

3 years ago

How to allow only 1 user to register in a Laravel application

How to enforce only one user to register or be registered in a Laravel web…

3 years ago