nn Posts - Answer Overflow

•Created by nn on 10/22/2023 in #❓┊help

Filtering options in RelationManager

I have four Resources: GameMatch, Event, Player, Team I have a RelationManager inside the GameMatch resource, for Events. It's successfully working. I have a Select for player_id, when creating a new event on that modal, but it shows all the players of the database. My wish would be to show only the players with a team_id equal to home_team_id or away_team_id from the GameMatch. The code I conjured up is the following:

                Select::make('player_id')
                    ->relationship(
                        name: 'player',
                        titleAttribute: 'team_id',
                        modifyQueryUsing: function (Builder $query){
                            $home_id = GameMatch::query()->pluck('home_team_id');
                            return $query->where('team_id',$home_id);
                        }
                    )
                    ->getOptionLabelFromRecordUsing(function (Player $record) {
                        $team = Team::find($record->team_id);
                        return "{$record->name} : {$team->name}";
                    })
                    ->preload()
                    ->searchable()
                    ->required(),

                Select::make('player_id')
                    ->relationship(
                        name: 'player',
                        titleAttribute: 'team_id',
                        modifyQueryUsing: function (Builder $query){
                            $home_id = GameMatch::query()->pluck('home_team_id');
                            return $query->where('team_id',$home_id);
                        }
                    )
                    ->getOptionLabelFromRecordUsing(function (Player $record) {
                        $team = Team::find($record->team_id);
                        return "{$record->name} : {$team->name}";
                    })
                    ->preload()
                    ->searchable()
                    ->required(),

However I'm receiving a Invalid parameter number, although the query that's displayed on that dialog produces the right results when querying the database. I'm sure I'm doing something wrong but can't figure out what. Thanks for any help.

3 replies

Gaming

Programming