F
Filament•2mo ago
Adnan Yalahow

weird select option behavior on relationship

i have this select option 
Forms\Components\Select::make('customer_id')
                    ->label('Customer')->live(debounce: 300)
                    ->required()->searchable()
                    ->relationship('customer', ignoreRecord: true)
                    ->getOptionLabelFromRecordUsing(function (Model $record) {
                        return $record['name'];
                    })
                    ->options(function (Forms\Get $get) {
                        if ($get('related_to')) {
                            $data = [];
                            if ($get('related_to') === 'fcl job') {
                                $data = Customer::whereHas('fcl_expense', function ($query) {
                                    $query->where('status', 'pending')->where('stage', 'approved');
                                })->get();
                            } elseif ($get('related_to') === 'lcl job') {
                                $data = Customer::whereHas('lcl_expense', function ($query) {
                                    $query->where('status', 'pending')->where('stage', 'approved');
                                })->get();
                            } elseif ($get('related_to') === 'clearance') {
                                $data = Customer::whereHas('clearance_expense', function ($query) {
                                    $query->where('status', 'pending')->where('stage', 'approved');
                                })->get();
                            }
                            return $data->pluck('name', 'id');
                        }
                    })
Forms\Components\Select::make('customer_id')
                    ->label('Customer')->live(debounce: 300)
                    ->required()->searchable()
                    ->relationship('customer', ignoreRecord: true)
                    ->getOptionLabelFromRecordUsing(function (Model $record) {
                        return $record['name'];
                    })
                    ->options(function (Forms\Get $get) {
                        if ($get('related_to')) {
                            $data = [];
                            if ($get('related_to') === 'fcl job') {
                                $data = Customer::whereHas('fcl_expense', function ($query) {
                                    $query->where('status', 'pending')->where('stage', 'approved');
                                })->get();
                            } elseif ($get('related_to') === 'lcl job') {
                                $data = Customer::whereHas('lcl_expense', function ($query) {
                                    $query->where('status', 'pending')->where('stage', 'approved');
                                })->get();
                            } elseif ($get('related_to') === 'clearance') {
                                $data = Customer::whereHas('clearance_expense', function ($query) {
                                    $query->where('status', 'pending')->where('stage', 'approved');
                                })->get();
                            }
                            return $data->pluck('name', 'id');
                        }
                    })
when am in create form no data is displayed in the select options and on edit the name of the customer can bee seen as label on the otherhand if I comment the relationship function the opposite happens in create the select option is ok but in edit i see the id and not the name I need help Please
Solution:
this is still making no difference but Thank God i figured out something that solved my problem and this is what i did ```php Forms\Components\Select::make('customer_id') ->label('Customer')->live() ->required()->searchable()->preload()...
Jump to solution
12 Replies
Adnan Yalahow
Adnan Yalahow•2mo ago
can someone provide solution for me please any volunteers please 🙏
Tally
Tally•2mo ago
like Adam said in another post: "Options and relationship don’t work together. One will always override the other."
Adnan Yalahow
Adnan Yalahow•2mo ago
so how do i prevent that i need to get customers using a relationship while showing the name in edit
Tally
Tally•2mo ago
Adnan Yalahow
Adnan Yalahow•2mo ago
Ihave done this 
Forms\Components\Select::make('customer_id')
                    ->label('Customer')->live(debounce: 300)
                    ->required()->searchable()
                    ->relationship(
                        name: 'customer',
                        titleAttribute: 'name',
                        modifyQueryUsing: function (Forms\Get $get, Builder $query) {
                            if ($get('related_to')) {
                                $data = [];
                                if ($get('related_to') === 'fcl job') {
                                    $data = $query->whereHas('fcl_expense', function ($fclQuery) {
                                        $fclQuery->where('status', 'pending')->where('stage', 'approved');
                                    })->get();
                                } elseif ($get('related_to') === 'lcl job') {
                                    $data = $query->whereHas('lcl_expense', function ($LCLQuery) {
                                        $LCLQuery->where('status', 'pending')->where('stage', 'approved');
                                    })->get();
                                } elseif ($get('related_to') === 'clearance') {
                                    $data = $query->whereHas('clearance_expense', function ($clQuery) {
                                        $clQuery->where('status', 'pending')->where('stage', 'approved');
                                    })->get();
                                }
                                return $data->pluck('name', 'id');
                            }
                        },
                        ignoreRecord: true,
                    )
                    ->getOptionLabelFromRecordUsing(function (Model $record) {
                        return $record['name'];
                    }),
Forms\Components\Select::make('customer_id')
                    ->label('Customer')->live(debounce: 300)
                    ->required()->searchable()
                    ->relationship(
                        name: 'customer',
                        titleAttribute: 'name',
                        modifyQueryUsing: function (Forms\Get $get, Builder $query) {
                            if ($get('related_to')) {
                                $data = [];
                                if ($get('related_to') === 'fcl job') {
                                    $data = $query->whereHas('fcl_expense', function ($fclQuery) {
                                        $fclQuery->where('status', 'pending')->where('stage', 'approved');
                                    })->get();
                                } elseif ($get('related_to') === 'lcl job') {
                                    $data = $query->whereHas('lcl_expense', function ($LCLQuery) {
                                        $LCLQuery->where('status', 'pending')->where('stage', 'approved');
                                    })->get();
                                } elseif ($get('related_to') === 'clearance') {
                                    $data = $query->whereHas('clearance_expense', function ($clQuery) {
                                        $clQuery->where('status', 'pending')->where('stage', 'approved');
                                    })->get();
                                }
                                return $data->pluck('name', 'id');
                            }
                        },
                        ignoreRecord: true,
                    )
                    ->getOptionLabelFromRecordUsing(function (Model $record) {
                        return $record['name'];
                    }),
now in edit its showing id instead of name and in create am not getting any options what am i doing wrong?
Tally
Tally•2mo ago
ray or dd the $data in your create to check the query... maybe the related_to field is null in create...
Adnan Yalahow
Adnan Yalahow•2mo ago
i tried to dd the $data before if ($get('related_to')) still nothing is shown
Tally
Tally•2mo ago
ok so the relationship is not being loaded? already tried ->preload()
LeandroFerreira
LeandroFerreira•2mo ago
Adnan Yalahow
Adnan Yalahow•2mo ago
still no change this is what i did 
->relationship(
                        name: 'customer',
                        titleAttribute: 'name',
                        modifyQueryUsing: function (Forms\Get $get, Builder $query) {
                            if ($get('related_to')) {
                                if ($get('related_to') === 'fcl job') {
                                   return $query->whereHas('fcl_expense', function ($fclQuery) {
                                        $fclQuery->where('status', 'pending')->where('stage', 'approved');
                                    })->pluck('name', 'id');
                                } elseif ($get('related_to') === 'lcl job') {
                                    return $query->whereHas('lcl_expense', function ($LCLQuery) {
                                        $LCLQuery->where('status', 'pending')->where('stage', 'approved');
                                    })->pluck('name', 'id');
                                } elseif ($get('related_to') === 'clearance') {
                                   return $query->whereHas('clearance_expense', function ($clQuery) {
                                        $clQuery->where('status', 'pending')->where('stage', 'approved');
                                    })->pluck('name', 'id');
                                }
                            }
                        },
                        ignoreRecord: true,
                    )
                    ->getOptionLabelFromRecordUsing(function (Model $record) {
                        return $record['name'];
                    })
->relationship(
                        name: 'customer',
                        titleAttribute: 'name',
                        modifyQueryUsing: function (Forms\Get $get, Builder $query) {
                            if ($get('related_to')) {
                                if ($get('related_to') === 'fcl job') {
                                   return $query->whereHas('fcl_expense', function ($fclQuery) {
                                        $fclQuery->where('status', 'pending')->where('stage', 'approved');
                                    })->pluck('name', 'id');
                                } elseif ($get('related_to') === 'lcl job') {
                                    return $query->whereHas('lcl_expense', function ($LCLQuery) {
                                        $LCLQuery->where('status', 'pending')->where('stage', 'approved');
                                    })->pluck('name', 'id');
                                } elseif ($get('related_to') === 'clearance') {
                                   return $query->whereHas('clearance_expense', function ($clQuery) {
                                        $clQuery->where('status', 'pending')->where('stage', 'approved');
                                    })->pluck('name', 'id');
                                }
                            }
                        },
                        ignoreRecord: true,
                    )
                    ->getOptionLabelFromRecordUsing(function (Model $record) {
                        return $record['name'];
                    })
Tally
Tally•2mo ago
pluck returns a collection if you want to limit the fields returned by the database you probably want to use ->select()
Solution
Adnan Yalahow
Adnan Yalahow•2mo ago
this is still making no difference but Thank God i figured out something that solved my problem and this is what i did 
    Forms\Components\Select::make('customer_id')
                    ->label('Customer')->live()
                    ->required()->searchable()->preload()
                    ->relationship(name: 'customer', titleAttribute: 'name',ignoreRecord: true)
                    ->options(function (Forms\Get $get, Builder $query) {
                        if ($get('related_to')) {
                            $data = [];
                            if ($get('related_to') === 'fcl job') {
                                $data = Customer::whereHas('fcl_expense', function ($query) {
                                    $query->where('status', 'pending')->where('stage', 'approved');
                                })->get();
                            } elseif ($get('related_to') === 'lcl job') {
                                $data = Customer::whereHas('lcl_expense', function ($query) {
                                    $query->where('status', 'pending')->where('stage', 'approved');
                                })->get();
                            } elseif ($get('related_to') === 'clearance') {
                                $data = Customer::whereHas('clearance_expense', function ($query) {
                                    $query->where('status', 'pending')->where('stage', 'approved');
                                })->get();
                            }
                            return $data->pluck('name', 'id');
                        }
                    })
    Forms\Components\Select::make('customer_id')
                    ->label('Customer')->live()
                    ->required()->searchable()->preload()
                    ->relationship(name: 'customer', titleAttribute: 'name',ignoreRecord: true)
                    ->options(function (Forms\Get $get, Builder $query) {
                        if ($get('related_to')) {
                            $data = [];
                            if ($get('related_to') === 'fcl job') {
                                $data = Customer::whereHas('fcl_expense', function ($query) {
                                    $query->where('status', 'pending')->where('stage', 'approved');
                                })->get();
                            } elseif ($get('related_to') === 'lcl job') {
                                $data = Customer::whereHas('lcl_expense', function ($query) {
                                    $query->where('status', 'pending')->where('stage', 'approved');
                                })->get();
                            } elseif ($get('related_to') === 'clearance') {
                                $data = Customer::whereHas('clearance_expense', function ($query) {
                                    $query->where('status', 'pending')->where('stage', 'approved');
                                })->get();
                            }
                            return $data->pluck('name', 'id');
                        }
                    })
in edit I see the name and in create I see my customers with certain conditions. And thank you guys for taking time to solve this too.
Want results from more Discord servers?
Add your server
More Posts
Grouping by parent in a Select componentI have a 3 models - `Brief`, `CustomOption` and `CustomOptionType`. Each `Brief` belongs to many `CuIs it possible to add a record directly in the table rather than using a form?I want to use the relation manage to show the related table and then quickly add a lot of records toAvoid duplicate codeGood morning, Lets say I have two resources: -> Brands -> Ingredients Both have a relation with Target [Filament\Tables\Contracts\HasTable] is not instantiable while building [Filament\Tables\TablTarget [Filament\Tables\Contracts\HasTable] is not instantiable while building [Filament\Tables\TablStarting overHi, I have tried a number of things to get the initial panels going but continue to get an error "Table SelectColumn With MultipleAdd the functionality to Table SelectColumn to select multiple optionsSearch my mutatorsHello,i have 2 models User and Pet Each pet belongs to a user and each user have firstname and surnalaravel starter kitplease help laravel stater kit[filament-socialite] How to logout from socialite (okta) when user logout from filament?Hi, I'm new to Filament and Filament-Socialite. I'm able to login to filament through Okta however wHow to order navigation group?