Sort with nulls last?

There's any way to create a custom sorting that will make NULLs stay last?

16 Replies

Depends do you want them last but then ascend 1-2-3-4-NULL

PicoléOP•2y ago

exactly, but I mean, there's any way to do custom sorting? I think I could figure something out from here I really didn't find anything about it in the docs but now thinking about it, I probably could rewrite the order inside getEloquentQuery but this would totally break the non-default column sorting

toeknee•2y ago

You should be able to write a custom query and a temporary table, so creating a high number where null. Just apply it where no sorting is applied in the eloquent query

Kenneth Sese•2y ago

@pedro.gabriel What are you trying to sort? A specific column I assume but what type of column and what does it contain?

PicoléOP•2y ago

it's a date column

Kenneth Sese•2y ago

So you want the dates ascending but records without a date (null) to be last.

PicoléOP•2y ago

exactly this

Kenneth Sese•2y ago

And then when sorting desc the null would be first and then desc?

PicoléOP•2y ago

when sorting again I really don't care, I mean I just wanted to set the default sorting

Kenneth Sese•2y ago

Here you go. Add this to your created_at column (or whatever your date column is): ->sortable(query: fn (Builder $query) => $query->orderByRaw('-created_at desc')) and then add ->defaultSort('created_at') to your table.

PicoléOP•2y ago

I had no idea the sortable had effect like this in the defaultSort I'll test it thanks a lot for the help (once again) @kennethsese

Kenneth Sese•2y ago

My pleasure!

PicoléOP•2y ago

it worked perfectly, thanks a lot

Kenneth Sese•2y ago

The only thing I'm noticing is that since we're hard coding the sort direction you can never sort 'asc'...not sure a good solution for that. @pedro.gabriel Here's the fix so it always sorts correctly:

->sortable(query: function (Builder $query, Livewire $livewire) {
                        return $livewire->tableSortDirection === 'asc'
                            ? $query->orderByRaw('-created_at desc')
                            : $query->orderBy('created_at', 'desc');
                    })

->sortable(query: function (Builder $query, Livewire $livewire) {
                        return $livewire->tableSortDirection === 'asc'
                            ? $query->orderByRaw('-created_at desc')
                            : $query->orderBy('created_at', 'desc');
                    })

make sure you import Livewire above:

use Livewire\Component as Livewire;

use Livewire\Component as Livewire;

Dan Harrin•2y ago

->sortable(query: function (Builder $query, string $direction) {
                        return $direction === 'asc'
                            ? $query->orderByRaw('-created_at desc')
                            : $query->orderBy('created_at', 'desc');
                    })

->sortable(query: function (Builder $query, string $direction) {
                        return $direction === 'asc'
                            ? $query->orderByRaw('-created_at desc')
                            : $query->orderBy('created_at', 'desc');
                    })

no need to use $livewire here

Kenneth Sese•2y ago

I thought that was an option but it wasn’t coming up in my ide so I didn’t even try 🤦‍♂️. Thanks!

Gaming

Programming

Sort with nulls last?

Did you find this page helpful?