N+1 Query for Text Column in Tables

I have this model, Domain.
Domain has many Config Mappings.
Config Mappings belongs to Config Directory.

What I want to achieve is to:
1. Show the config id and and the directory as badge.
2. When a badge is clicked, open a new tab for the clicked badge.

This is what I have so far, but this is doing N+1 Query.

TextColumn::make('configMappings.configDirectory.id')
                    ->label('Config Info')
                    ->badge()
                    ->separator(',')
                    ->formatStateUsing(function ($state) {
                        $configDirectory = ConfigDirectory::find($state);
                        $configId = $configDirectory->config_id;
                        $directory = $configDirectory->directory;
                        return "#{$configId} - {$directory}";
                    }),

TextColumn::make('configMappings.configDirectory.id')
                    ->label('Config Info')
                    ->badge()
                    ->separator(',')
                    ->formatStateUsing(function ($state) {
                        $configDirectory = ConfigDirectory::find($state);
                        $configId = $configDirectory->config_id;
                        $directory = $configDirectory->directory;
                        return "#{$configId} - {$directory}";
                    }),

Filament•9mo ago•

4 replies

keriman777

N+1 Query for Text Column in Tables

TextColumn::make('configMappings.configDirectory.id')
                    ->label('Config Info')
                    ->badge()
                    ->separator(',')
                    ->formatStateUsing(function ($state) {
                        $configDirectory = ConfigDirectory::find($state);
                        $configId = $configDirectory->config_id;
                        $directory = $configDirectory->directory;
                        return "#{$configId} - {$directory}";
                    }),

TextColumn::make('configMappings.configDirectory.id')
                    ->label('Config Info')
                    ->badge()
                    ->separator(',')
                    ->formatStateUsing(function ($state) {
                        $configDirectory = ConfigDirectory::find($state);
                        $configId = $configDirectory->config_id;
                        $directory = $configDirectory->directory;
                        return "#{$configId} - {$directory}";
                    }),

N+1 Query for Text Column in Tables

Similar Threads

N+1 Query for Text Column in Tables

Similar Threads

Similar Threads

Similar Threads