F
Filament•2mo ago
Prodex

How can I avoid N+1 problem in custom views?

As described in the docs I use a custom view for a table column and I'm using $getRecord() to access the eloquent model. This however makes an N+1 problem, because for every record displayed in the table the $getRecord() method retrieves the data from the database again. How can I avoid this? Thank you!
Solution:
Hi, this should help you: ```php return $table...
Jump to solution
3 Replies
Solution
ModestasV
ModestasV•2mo ago
Hi, this should help you: 
        return $table
            ->modifyQueryUsing(function ($query) {
                return $query->with('relationship');
            })
        return $table
            ->modifyQueryUsing(function ($query) {
                return $query->with('relationship');
            })
ModestasV
ModestasV•2mo ago
On the table, you can modify the query and add eager loading as needed
Prodex
Prodex•2mo ago
perfect, that worked. Thank you!
Want results from more Discord servers?
Add your server
More Posts
update defaultItems repeater with an other fieldsHi everyone, I need that when changing the value of a field, I can create a logic to dynamically geFileopload relationshipHi, I hope you're well! I am a Senegalese developer and I would like to thank you for your work on fHow to Prevent Laravel filament table in a resource from loading until a filter action is initiatedI have a database table with a lot of data. I don't want to load all the data into the table in a reEdit view from relationManagerHello team, quick question. Is there a simple way to edit the pop up that appears as a preview of socreate actionhello all, i have a resource, after save a record, i wish to update a field value to other data. soModify Relation Manager query and get data that are not only related to ownerRecordI am making an application where I have a Category, Product, Variation models. A category can have mEditing select label with pivot valuesI have this form in a repeater form: ```php Forms\Components\Select::make('user_id') ->label(__(Can I add multiple menu items for same resource e.g. My Contacts & All Contacts?When selecting any menu item, it will open ContactResource and a filter will be added based on the lConditionally rendering an icon in TextColumnI have a situation where the value of a cell could be "true" or anything else. How can I render an iUsing Filament with Tailwind PrefixIs it possible to use filament when we are using the tailwind prefix (eg in our case we are using 't