relationship with trashed

When using relationship() how do we handle loading trashed items into the field?

excample:

                                CheckboxList::make('teams')
                                    ->label('Assigned Team(s)')
                                    ->required()
                                    ->relationship('teams', 'name',
                                        function (Builder $query) {
                                            return $query->select(['id', \DB::Raw('CONCAT(name, \' - \', custom_field) as name')]);
                                        }
                                    )
                                    ->reactive()
                                    ->columnSpanFull(),

                                CheckboxList::make('teams')
                                    ->label('Assigned Team(s)')
                                    ->required()
                                    ->relationship('teams', 'name',
                                        function (Builder $query) {
                                            return $query->select(['id', \DB::Raw('CONCAT(name, \' - \', custom_field) as name')]);
                                        }
                                    )
                                    ->reactive()
                                    ->columnSpanFull(),

                                CheckboxList::make('teams')
                                    ->label('Assigned Team(s)')
                                    ->required()
                                    ->relationship('teams', 'name',
                                        function (Builder $query) {
                                            return $query->select(['id', \DB::Raw('CONCAT(name, \' - \', custom_field) as name')]);
                                        }
                                    )
                                    ->reactive()
                                    ->columnSpanFull(),

                                CheckboxList::make('teams')
                                    ->label('Assigned Team(s)')
                                    ->required()
                                    ->relationship('teams', 'name',
                                        function (Builder $query) {
                                            return $query->select(['id', \DB::Raw('CONCAT(name, \' - \', custom_field) as name')]);
                                        }
                                    )
                                    ->reactive()
                                    ->columnSpanFull(),

Patrick Boivin•6/22/23, 12:38 PM

If I'm reading this right, would this depend on how you generate $allTeams$allTeams?

PPatrick Boivin If I'm reading this right, would this depend on how you generate `$allTeams`?

toekneeOP•6/22/23, 12:39 PM

Ahh no, that makes no difference. It was then from being a standard non-relationship select

toekneeOP•6/22/23, 12:40 PM

Updated, it's the relationship which applies withoutTrashed by default

LeandroFerreira•6/22/23, 12:42 PM

Did you try ->withTrashed()->get()...->withTrashed()->get()... ?

LLeandroFerreira Did you try `->withTrashed()->get()...` ?

toekneeOP•6/22/23, 12:43 PM

Can't use ->get() in the builder. But I tried ->withTrashed() on the query->select i.e.

return $query->select(['id', \DB::Raw('CONCAT(name, \' - \', custom_field) as name')])->withTrashed();

return $query->select(['id', \DB::Raw('CONCAT(name, \' - \', custom_field) as name')])->withTrashed();

Patrick Boivin•6/22/23, 12:44 PM

Do you still get a result here or some error? ^

PPatrick Boivin Do you still get a result here or some error? ^

toekneeOP•6/22/23, 12:44 PM

Nothing, it just doesn't apply

Patrick Boivin•6/22/23, 12:45 PM

Ok... Not sure but I think using ->select()->select() messes with the available columns in the query... so you might have to do the equivalent of withTrashed()withTrashed() manually, by checking the deleted_atdeleted_at column

toekneeOP•6/22/23, 12:46 PM

Ok thanks! I'll have a play a bit more

toekneeOP•6/22/23, 12:51 PM

Thanks Guys, so ->withTrashed() worked but my CONCAT was only working when custom_field had a value

Patrick Boivin•6/22/23, 12:52 PM

Oh, cool! Did you modify the DB::raw() in any way? (just curious)

toekneeOP•6/22/23, 12:54 PM

Yep, I chucked an IFNULL in so:

return $query->select(['id', \DB::Raw('CONCAT(name, \' - \', IFNULL(custom_field, \'\')) as name')])->whereNotNull('name')->withTrashed();

return $query->select(['id', \DB::Raw('CONCAT(name, \' - \', IFNULL(custom_field, \'\')) as name')])->whereNotNull('name')->withTrashed();

Ttoeknee Yep, I chucked an IFNULL in so: ```php return $query->select(['id', \DB::Raw('C...

LeandroFerreira•6/22/23, 1:04 PM

what about this?

->relationship('teams', 'name', function (Builder $query) {
    return $query->withTrashed();
})
->getOptionLabelFromRecordUsing(fn (Model $record) => "{$record->name} - {$record->custom_field}")

->relationship('teams', 'name', function (Builder $query) {
    return $query->withTrashed();
})
->getOptionLabelFromRecordUsing(fn (Model $record) => "{$record->name} - {$record->custom_field}")

LLeandroFerreira what about this? ```php ->relationship('teams', 'name', function (Builder $query...

toekneeOP•6/22/23, 1:09 PM

Ohhhh Leandro!

toekneeOP•6/22/23, 1:09 PM

That's mucho better. I forgot about option label