Need help with SQL query

[musiccollect]

Package

Panel builder

Package Version

v3.0.0

How can we help you?

I've tried every combination of getEloquentQuery, applySearchToTableQuery and modifyQueryUsing but getting nowhere. If I hardcode the value of $tableSearch, the table pulls the results from the database almost instantly but typing the value in the tableSearch box (as a user would do), takes ages to pull up the results. Same thing with or without DebugBar. I've tried this in both the resource page and the resource's list page. This is currently in the resource page:

public static function table(Table $table): Table
{
$tableSearch = request()->input('tableSearch');
$tableSearch = "The Dark Side Of The Moon";
return $table
->columns([
Tables\Columns\TextColumn::make('id')
->label('Release Track ID')
->hidden(),
Tables\Columns\TextColumn::make('title')
->sortable()
->searchable(isIndividual: false, isGlobal: true),
])
->searchable()
->paginated([10, 25, 50])
->defaultPaginationPageOption(10)
->searchOnBlur()
->modifyQueryUsing(fn (Builder $query) => $query->where('title', 'like', $tableSearch . '%'));
}

Any ideas ?

Thanks, Greg

[leandrocfe]

You can inject $request

->modifyQueryUsing(fn (Builder $query, Request $request) => $query->where('title', 'like', '%'.$request->tableSearch.'%'))

[musiccollect]

Thanks for the quick response. Using that code I get : Target class [App\Filament\Resources\Request] does not exist.

…

On Sat, Mar 23, 2024 at 8:41 PM Leandro Ferreira ***@***.***> wrote: You can inject $request ->modifyQueryUsing(fn (Builder $query, Request $request) => $query->where('title', 'like', '%'.$request->tableSearch.'%')) — Reply to this email directly, view it on GitHub <#11994 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ARHP4KWH5DQM5LMMFO6QNETYZVE53AVCNFSM6AAAAABFEB4LF6VHI2DSMVQWIX3LMV43SRDJONRXK43TNFXW4Q3PNVWWK3TUHM4DQOBVGYZTI> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[leandrocfe]

use Illuminate\Http\Request;

[musiccollect]

Thanks again. I added the use import but still same issue to begin with. I'm now looking at various options with Livewire on the frontend. Testing in that appears to be lightning-fast and could be the solution.

[flightphysical]

I don't have a solution yet, am trying to make sure I have imported the correct Builder Class, I am trying this one with intermittent results, not fully solved yet:

use Illuminate\Contracts\Database\Query\Builder;

anyone get this working yet?