CrudPanel.php - 492

[backpack-operations]

Hello team, i just received this on email:

[jcastroa87]

Hello @backpack-operations

Can you ask to the user share the model to replicate the issue and check about the relations.

Thanks.

Cheers.

[zivarg]

class Owner extends Model { use CrudTrait; use HasFactory; use HasUuids;

/*
|--------------------------------------------------------------------------
| GLOBAL VARIABLES
|--------------------------------------------------------------------------
*/

// protected $fillable = [];
protected $guarded = ['id'];
// protected $hidden = [];
// protected $primaryKey = 'id';
protected $table = 'owners';
// public $timestamps = false;

/*
|--------------------------------------------------------------------------
| RELATIONS
|--------------------------------------------------------------------------
*/

public function phoneNumbers(): HasMany
{
    return $this->hasMany(OwnersPhoneNumber::class, 'owner_id');
}

}

[zivarg]

class OwnersPhoneNumber extends Pivot { use CrudTrait; use HasFactory; use HasUuids;

/*
|--------------------------------------------------------------------------
| GLOBAL VARIABLES
|--------------------------------------------------------------------------
*/

// protected $fillable = [];
protected $guarded = ['id'];
// protected $hidden = [];
// protected $primaryKey = 'id';
protected $table = 'owners_phone_numbers';
// public $timestamps = false;

/*
|--------------------------------------------------------------------------
| RELATIONS
|--------------------------------------------------------------------------
*/

public function jobTitle(): BelongsTo
{
    return $this->belongsTo(JobTitle::class, 'owner_id');
}

}

[zivarg]

class JobTitle extends Model { use CrudTrait; use HasFactory; use HasUuids;

/*
|--------------------------------------------------------------------------
| GLOBAL VARIABLES
|--------------------------------------------------------------------------
*/

// protected $fillable = [];
protected $guarded = ['id'];
// protected $hidden = [];
// protected $primaryKey = 'id';
protected $table = 'job_titles';
// public $timestamps = false;

}

[zivarg]

In fileds everything works as it should, but in columns it doesn't, and specifically when I have subfields -> select inside relationship.

[zivarg]

CRUD::column([ 'entity' => 'phoneNumbers', 'label' => 'Phone numbers', 'name' => 'phoneNumbers', 'priority' => 1, 'subfields' => [ [ 'attribute' => 'name', 'entity' => 'jobTitle', 'label' => "Owner job title of phone number", 'name' => 'owner_job_title_id', 'type' => 'select'

            ],
        ],
        'type' => "relationship"
    ]);

[zivarg]

@backpack-operations

[pxpm]

@zivarg try using the column as following:

CRUD::column('phoneNumbers.jobTitle.name');

I am assigning my college (@jcastroa87) that received this issue so that if my solution doesn't work he can followup with you 👍