BelongsToMany Full Name Accessor

I have

    public function courses()
    {
        return $this->belongsToMany(Course::class);
    }

    public function courses()
    {
        return $this->belongsToMany(Course::class);
    }

in Course Model have

public function getFullNameAttribute()
    {
        return $this->department->name . ' ' . $this->course . ' ' . __('term');
    }

public function getFullNameAttribute()
    {
        return $this->department->name . ' ' . $this->course . ' ' . __('term');
    }

When call Tables\Columns\TextColumn::make('courses.full_name') Getting empty field. How can I solve this?

14 Replies

toeknee•2mo ago

This is because we use the column names in the query, not as an accessor. do

Tables\Columns\TextColumn::make('courses.full_name')
  ->getStateUsing(fn($record) => $record->courses->full_name)

Tables\Columns\TextColumn::make('courses.full_name')
  ->getStateUsing(fn($record) => $record->courses->full_name)

ArshavirOP•2mo ago

getting Property [full_name] does not exist on this collection instance.

toeknee•2mo ago

try $record->courses->fullName

ArshavirOP•2mo ago

already tried with this:

Tables\Columns\TextColumn::make('courses')
                    ->formatStateUsing(fn(Model $state) => $state->full_name)

Tables\Columns\TextColumn::make('courses')
                    ->formatStateUsing(fn(Model $state) => $state->full_name)

fullName not resolving

LeandroFerreira•2mo ago

personally, I would create a virtual column and use courses.full_name

Checkbox list - Form Builder - Filament

ArshavirOP•2mo ago

this one working fine Also I noted if working with belongsTo then Tables\Columns\TextColumn::make('course.full_name') working virtual column much better as @Leandro Ferreira described!

LeandroFerreira•2mo ago

yes, and you can also use this with ->searchable()

ArshavirOP•2mo ago

I use searchable with array like searchable(['name', 'surname']) Can you explain why course.full_name working, but courses.full_name not working. belongsTo vs belongsToMany

LeandroFerreira•2mo ago

I think this should work..

ArshavirOP•2mo ago

When call Tables\Columns\TextColumn::make('courses.full_name') Getting empty field.

LeandroFerreira•2mo ago

Did you try another column?

ArshavirOP•2mo ago

yes Tables\Columns\TextColumn::make('courses.course') working

protected $fillable = [
        'department_id',
        'course',
    ];

protected $fillable = [
        'department_id',
        'course',
    ];

public function getFullNameAttribute()
    {
        return $this->department->name . ' ' . $this->course . ' ' . __('term');
    }

public function getFullNameAttribute()
    {
        return $this->department->name . ' ' . $this->course . ' ' . __('term');
    }

in Subject Model

LeandroFerreira•2mo ago

I thought you were using virtual column..

ArshavirOP•2mo ago

I don't using virtual column, because I use JSON fields for multilanguage.

Gaming

Programming

BelongsToMany Full Name Accessor