Filament•8mo ago

Trouble Displaying / Updating Pivot Table Data with Same Names as Parent Model

Problem Description: I'm having trouble showing, updating data from a pivot table. The issue is that some column names in my pivot table are the same as in my main model, and it's causing a conflict. Details: My main model is called Experience.php. It shares some column names (is_enabled, is_preview, is_premium) with the pivot table. Challenge: I can display data from the pivot table in my app, but when the column names overlap with those in Experience.php, it doesn't work properly. How can I fix this so I can display all the data correctly?

6 Replies

Povilas K•8mo ago

My guess is that you didn't follow this line from the docs: "Please ensure that any pivot attributes are listed in the withPivot() method of the relationship and inverse relationship." So you need to define the relationship in the Experience model, too, not only in Card Docs: https://filamentphp.com/docs/3.x/panels/resources/relation-managers#listing-with-pivot-attributes

Managing relationships - Panel Builder - Filament

tadas322OP•8mo ago

@PovilasKorop, thank you for the idea, but I rechecked the Experience model and found that I already have this line.

Povilas K•8mo ago

Shame that my idea didn't work, maybe it's something else, then. To me, pivot toggle always worked with my examples.

tadas322OP•8mo ago

Even in the same situation when attributes overlap like in my case? I will clarify. That table shows only the fields from Experience.php: is_premium, is_preview, is_enabled. However, I don't know how to display fields with the same names from the pivot table.

Povilas K•8mo ago

It's hard to reproduce exactly your case, I tried with different fields like users.is_active and role_user.is_active and it worked: relation manager showed role_user.is_active as a toggle properly. So maybe I misunderstand your situation.

AlexAnder•4w ago

I have MorphToMany and also on relationManager, creating or editing related record, pivot column "description" doesn't updates or doesn't fill in edit form. The model:

class People extends Model
{
    use HasLocks;
    use SoftDeletes;

    protected $fillable = [
        'name',
        'dob',
        'description',
    ];

    public function signals(): MorphToMany
    {
        return $this->morphToMany(Signal::class, 'signalable')
            ->withPivot(['id', 'description']);
    }
}

class Signal extends Model
{
    use HasLocks;
    use SoftDeletes;

    protected $fillable = [
        'name',
        'date',
        'description',
    ];

    public function peoples(): MorphToMany
    {
        return $this->morphedByMany(People::class, 'signalable')
            ->withPivot(['id', 'description']);
    }

class People extends Model
{
    use HasLocks;
    use SoftDeletes;

    protected $fillable = [
        'name',
        'dob',
        'description',
    ];

    public function signals(): MorphToMany
    {
        return $this->morphToMany(Signal::class, 'signalable')
            ->withPivot(['id', 'description']);
    }
}

class Signal extends Model
{
    use HasLocks;
    use SoftDeletes;

    protected $fillable = [
        'name',
        'date',
        'description',
    ];

    public function peoples(): MorphToMany
    {
        return $this->morphedByMany(People::class, 'signalable')
            ->withPivot(['id', 'description']);
    }

Gaming

Programming

Trouble Displaying / Updating Pivot Table Data with Same Names as Parent Model