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…

1 year ago

Merrimu Reservoir drone images

Merrimu Reservoir from drone. Click images to view larger.

1 year ago

FTP getting array of file details such as size using PHP

Using FTP and PHP to get an array of file details such as size and…

2 years ago

Creating Laravel form requests

Creating and using Laravel form requests to create cleaner code, separation and reusability for your…

2 years ago

Improving the default Laravel login and register views

Improving the default Laravel login and register views in such a simple manner but making…

2 years ago

Laravel validation for checking if value exists in the database

Laravel validation for checking if a field value exists in the database. The validation rule…

2 years ago