relation : How can i show the name and not the ID

Hi,

My code is :

Select::make('suivi_user_maintenance')
    ->relationship('suivipar', 'name',
        function ($query) {
            $query->where('statut', 1)
                ->with('role')
                ->whereHas('role', function ($q) {
                    $q->whereIn('name', ['S', 'RS', 'AF', 'AT']);
                })
                ->orderBy('name');
        }
    )

Select::make('suivi_user_maintenance')
    ->relationship('suivipar', 'name',
        function ($query) {
            $query->where('statut', 1)
                ->with('role')
                ->whereHas('role', function ($q) {
                    $q->whereIn('name', ['S', 'RS', 'AF', 'AT']);
                })
                ->orderBy('name');
        }
    )

Select::make('suivi_user_maintenance')
    ->relationship('suivipar', 'name',
        function ($query) {
            $query->where('statut', 1)
                ->with('role')
                ->whereHas('role', function ($q) {
                    $q->whereIn('name', ['S', 'RS', 'AF', 'AT']);
                })
                ->orderBy('name');
        }
    )

Select::make('suivi_user_maintenance')
    ->relationship('suivipar', 'name',
        function ($query) {
            $query->where('statut', 1)
                ->with('role')
                ->whereHas('role', function ($q) {
                    $q->whereIn('name', ['S', 'RS', 'AF', 'AT']);
                })
                ->orderBy('name');
        }
    )

and i don"t know how show the name and not the id on the front :

If you have any idees for helping me it will be nice

thanks you

bwurtz999•11/28/23, 2:28 PM

Looks like you can use ->getOptionLabelFromRecordUsing->getOptionLabelFromRecordUsing

bwurtz999•11/28/23, 2:29 PM

https://filamentphp.com/docs/3.x/forms/fields/select#customizing-the-relationship-option-labels

Select - Form Builder - Filament

bwurtz999•11/28/23, 2:29 PM

->getOptionLabelFromRecordUsing(function ($record) {
  // return whatever label you want
})

->getOptionLabelFromRecordUsing(function ($record) {
  // return whatever label you want
})

Iliyas M•11/29/23, 4:28 AM

Try this

Select::make('suivi_user_maintenance')
    ->relationship('suivipar', 'name',
        function ($query, $state) {
            $query
->where(fn ($q) => $q->where('statut', 1)
                ->with('role')
                ->whereHas('role', function ($q) {
                    $q->whereIn('name', ['S', 'RS', 'AF', 'AT']))
->when($state, fn ($q, $value) => $q->orWhere('id', $value));
                })
                ->orderBy('name');
        }
    )

Select::make('suivi_user_maintenance')
    ->relationship('suivipar', 'name',
        function ($query, $state) {
            $query
->where(fn ($q) => $q->where('statut', 1)
                ->with('role')
                ->whereHas('role', function ($q) {
                    $q->whereIn('name', ['S', 'RS', 'AF', 'AT']))
->when($state, fn ($q, $value) => $q->orWhere('id', $value));
                })
                ->orderBy('name');
        }
    )

relation : How can i show the name and not the ID

Similar Threads

Similar Threads

Similar Threads