Filter On Load Or URL

Hi all

I hope someone can help.

I have a table in a livewire component ( not panel ). I have a link on another page which directs to this table page and modifies the query:

>modifyQueryUsing(function (Builder $query) {

                // If client_id is in the GET
                if (request()->filled('client_id')) {
                    $query->where('client_id', request()->input('client_id'));
                }
}

>modifyQueryUsing(function (Builder $query) {

                // If client_id is in the GET
                if (request()->filled('client_id')) {
                    $query->where('client_id', request()->input('client_id'));
                }
}

>modifyQueryUsing(function (Builder $query) {

                // If client_id is in the GET
                if (request()->filled('client_id')) {
                    $query->where('client_id', request()->input('client_id'));
                }
}

>modifyQueryUsing(function (Builder $query) {

                // If client_id is in the GET
                if (request()->filled('client_id')) {
                    $query->where('client_id', request()->input('client_id'));
                }
}

Howver when I click on the next page in the pagination it is lost.

So I wondered if there a way to save this?
OR
Have a filter (client drop down) be selected on page load).

Solution

if you yuse

multiple()

multiple()

try

[request()->input('client_id')]

[request()->input('client_id')]

[request()->input('client_id')]

[request()->input('client_id')] because i believe it want a array.

Jump to solution

David | Fortune ValidatorOP•2/23/24, 7:33 AM

Any ideas anyone? Sorry for the bump

Tieme•2/23/24, 3:34 PM

Does something like this works for you?

Tables\Filters\SelectFilter::make('client_id')
    ->relationship('client','name')
    ->default(fn() => request()->filled('client_id') ? request()->input('client_id') : null),

Tables\Filters\SelectFilter::make('client_id')
    ->relationship('client','name')
    ->default(fn() => request()->filled('client_id') ? request()->input('client_id') : null),