keriman777
keriman777
PostsComments
FFilament
Created by keriman777 on 6/2/2025 in #❓┊help
Problem with createOptionUsing in Single Select
No description
3 replies
FFilament
Created by keriman777 on 5/23/2025 in #❓┊help
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}";
                    }),
5 replies