Add relationship() support to TextColumn

[somzoli]

I have two models:

• Rule
• Interface

Relations:
Rule:
public function IInterfaces() { return $this->belongsTo(IInterface::class, 'i_interface_id'); }
Interface:
public function Rules() { return $this->HasMany(Rule::class); }

But the interface model is usable as input interface and out interface. For this i have to add an extra foreign key to Rule table:

//IN
$table->foreignIdFor(Models\IInterface::class)->nullable()->cascadeOnDelete();
 //OUT
$table->foreignIdFor(Models\IInterface::class, 'out_i_interface_id')->nullable()->cascadeOnDelete();

In Rule form, i can use this, which is working fine:
Forms\Components\Select::make('out_i_interface_id') ->relationship('IInterfaces', 'name') ->label('OUT interface'),

But in Columns on Rule list, the "OUT" column can not use, because i cant define the relation that i want to use
Tables\Columns\TextColumn::make('out_i_interface_id') ->label('Out Interface') ->searchable() ->sortable(),
Describe the solution you'd like
Maybe can port relationship() from Select?

Can you help with this?
Thanks!

BR,
Z

[somzoli]

Hi,

I was able to solve this with add extra relations to Rule model:
public function OutIInterfaces() { return $this->belongsTo(IInterface::class, 'out_i_interface_id'); }

[sax1987]

I tried your process, but I got a data type problem, can you help me?

[sax1987]

I hope the images help you understand the problem a little.

[sax1987]

my person table would be your interface table

[somzoli]

Hi,

I think you have a typo issue.
When you define the relation in ->relationship() method, you have to give a table name instead of model name.

Test with like this:

Forms\Components\Select:: make ('persona id')
// -›options(Persona::all()->pluck( 'nombre_apellido', 'id'))
-›relationship ( 'personas', 'nombre_apellido')
->label (' Comprador' )
-›searchable()
->preload()
-›required(),
Forms\Components\Select:: make ('v persona id')
//-›options (Persona: :all() ->pluck('nombre_apellido', 'id'))
-›relationship ('personas', 'nombre_apellido' )
->label ('Vendedor')
-›searchable()
->preload ()
-yrequired（）.
Forms \Components\Select: make('r_persona_id' )
// -›options (Persona::all(->pluck( 'nombre_apellido', 'id'))
-›relationship( 'personas', 'nombre _apellido')
->label ('Responsable' )
-›searchable ()
->preload()
-›required(),

[somzoli]

Other issue can be:

if you use v_persona_id in textcolumn, u should use VPersonas function name in related model.

filament will calculate lile this:
VPersonas-> v_persona_id

public function VPersonas (): BelongsTo
return $this-›belongsTo(Persona: :class, 'v_persona_id');

[sax1987]

I already found the solution my friend thanks for the help