FilamentF
Filament•8mo ago
keriman777

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}";
                    }),
Was this page helpful?