F
Filament•5mo ago
BuddhaNature

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
Dennis Koch•5mo 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.
BuddhaNature
BuddhaNature•5mo 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
BuddhaNature•5mo 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
Dennis Koch•5mo ago
Sure. Query sets the initial query. That's why you don't get it as an argument. My bad
Want results from more Discord servers?
Add your server
More Posts
Tenant with an extra layer of ownership - uploading documentsHi. I have set up Filament with multitenancy, and I am using a classic "Team" model. I have one morMulti-tenancy panel giving 404I have followed the instructions for setting up multi-tenancy on https://filamentphp.com/docs/3.x/paI am using Laravel Scout with Meilisearch issue with Default SorttingI use Laravel Scout and Meilisearch and when I get results from Meilisearch they are in order of preAny route in web.php gives 404I would like to add a simple route in my Filament app like below: ```php Route::get('/test', functiUsing API call for multiple columns in a tableHello, I execute an API call to an external endpoint that I will use to fill multiple columns in 1 tLaravel filament UI not loading correctly after deploymentHello everyone, I have a problem that filament isnt loading correctly after deploying it via ploi. ILogin issue after deployingHi, I deployed a website this week, and I can't login to the filament panel, I know there is a modifenable select box search using livewire componentCan I enable search using using input.select on a custom livewire component? I can manage select buForm component Section have empty fields on edit entity pageWhen trying to open an editing page containing a section component, the fields of this section are nRichEditor doesn't upload Image on Simple Resource (Modal)Could anyone help me with this point pls ? Basically what I'm doing is creating a new RichEditor co