Filament•11mo ago

How can I limit the query on just one page using getEloquentQuery()

Hi. I don't need all the columns of a resource for my list page. How can I create a select() that only applies to the list page?

Solution:

The proper method seems to be

->modifyQueryUsing(fn (Builder $query) => $query->select(['id', 'title']))

->modifyQueryUsing(fn (Builder $query) => $query->select(['id', 'title']))

...

Jump to solution

4 Replies

Dennis Koch•11mo ago

There should be a ->query() method on the Table object.

$table->query(fn ($query) => $query->select(...))

$table->query(fn ($query) => $query->select(...))

Not sure whether Filament might apply it's own selection though.

BuddhaNatureOP•11mo ago

That generates this error: An attempt was made to evaluate a closure for [Filament\Tables\Table], but [$query] was unresolvable. I did a source dive and it seems like it should work. I can't find any references to that method in the Tab;e docs.

Solution

BuddhaNature•11mo ago

The proper method seems to be

->modifyQueryUsing(fn (Builder $query) => $query->select(['id', 'title']))

->modifyQueryUsing(fn (Builder $query) => $query->select(['id', 'title']))

Dennis Koch•11mo ago

Sure. Query sets the initial query. That's why you don't get it as an argument. My bad

Gaming

Programming

How can I limit the query on just one page using getEloquentQuery()