What is the best method to sort boolean columns

[carbtest]

with the following code

...,
BooleanColumn::make("Allow Multiple", 'allow_multiple')
    ->sortable(),
...

 public function builder(): Builder
    {
        return Field::query()->orderBy('name', 'asc');
    }

what is the best way to make the column sortable?

[lrljoe]

Don't set an orderBy in builder, as that will override any other sorts you're doing.

With that removed, your sortable() will work exactly as is

[carbtest]

What if I want an initial sort? Joe Bradfield ***@***.***

…

________________________________ From: Joe ***@***.***> Sent: Friday, June 28, 2024 10:26:37 PM To: rappasoft/laravel-livewire-tables ***@***.***> Cc: carbtest ***@***.***>; Author ***@***.***> Subject: Re: [rappasoft/laravel-livewire-tables] What is the best method to sort boolean columns (Discussion #1746) Don't set an orderBy in builder, as that will override any other sorts you're doing. What do you see with that removed? — Reply to this email directly, view it on GitHub<#1746 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/A6CG2TQ73G6J3SLTUP5SU2DZJZAQ3AVCNFSM6AAAAABKCTUJTKVHI2DSMVQWIX3LMV43SRDJONRXK43TNFXW4Q3PNVWWK3TUHM4TSMJQGM3DG>. You are receiving this because you authored the thread.Message ID: ***@***.***>

[lrljoe]

Perfectly possible

public function configure(): void
{
    $this->setDefaultSort('name', 'desc');
}

There's a ton of customisations etc, and they're fairly well documented, for example, the doc for setting a default sort is:
See Docs