Trying to show username but it is blank.

JJSanders · 2024-01-07T09:27:33.370Z

I have an OrderResource which I use to show Orders and OrderItems. Each order Item belongs to an Order and also to a User. In de repeater which I have in the Resource I want to show the Username who created the OrderItem (user.name) So I have done this: In the OrderItem Model I have created a relationship: ```php public function user(): BelongsTo { return $this->belongsTo(User::class); } ``` and in the OrderResource I have ```php return Repeater::make('items') ->relationship() ->schema([ TextInput::make('user.name') ->label('Ordered by') ->disabled(), ]); ``` However the user.name shows blank. How do I make this work?

H

Hussain4real•1/7/24, 10:20 AM

you need to specify the name of the relationship in the

->relationship()

->relationship()

->relationship()

->relationship() method

H

Hussain4real•1/7/24, 10:20 AM

if left blank it will assume the name is 'items'

H

Hussain4real•1/7/24, 10:21 AM

after that you don't need the 'user.name' just 'name'

J

JJSandersOP•1/7/24, 10:22 AM

I tried this:

relationship('users')

relationship('users')

relationship('users')

relationship('users')
But then I get this error:

Filament\Forms\Components\Repeater::getRelationship(): Return value must be of type Illuminate\Database\Eloquent\Relations\HasOneOrMany|Illuminate\Database\Eloquent\Relations\BelongsToMany|null, Illuminate\Database\Eloquent\Relations\BelongsTo returned

J

JJSandersOP•1/7/24, 10:22 AM

The OrderItem belongs to a user.

H

Hussain4real•1/7/24, 10:22 AM

you can't do that it works only on HasMany

H

Hussain4real•1/7/24, 10:24 AM

you can try setting an invereRelationship on the OrderItem resource and see

J

JJSandersOP•1/7/24, 10:25 AM

What do you mean with inverseRelationship on OrderItem?

H

Hussain4real•1/7/24, 10:25 AM

i think that only works for Relation Managers

H

Hussain4real•1/7/24, 10:26 AM

in your Repeater, instead of using relationship method use Section layout

J

JJSandersOP•1/7/24, 10:29 AM

But one second in My OrderResource I also have a User Relation and there it works.
So this works in my OrderResource

Tables\Columns\TextColumn::make('user.name')
    ->label('Created By')
    ->searchable()
    ->sortable(),

Tables\Columns\TextColumn::make('user.name')
    ->label('Created By')
    ->searchable()
    ->sortable(),

Tables\Columns\TextColumn::make('user.name')
    ->label('Created By')
    ->searchable()
    ->sortable(),

Tables\Columns\TextColumn::make('user.name')
    ->label('Created By')
    ->searchable()
    ->sortable(),

But in the repeater with Items this does not work:

return Repeater::make('items')
  ->relationship()
  ->schema([
    TextInput::make('user.name')
      ->label('Ordered by')
      ->disabled(),
]);

return Repeater::make('items')
  ->relationship()
  ->schema([
    TextInput::make('user.name')
      ->label('Ordered by')
      ->disabled(),
]);

return Repeater::make('items')
  ->relationship()
  ->schema([
    TextInput::make('user.name')
      ->label('Ordered by')
      ->disabled(),
]);

return Repeater::make('items')
  ->relationship()
  ->schema([
    TextInput::make('user.name')
      ->label('Ordered by')
      ->disabled(),
]);

Both the Order and the OrderItem have a BelongsTo User relationship

H

Hussain4real•1/7/24, 10:31 AM

have you tried something like this without the relationship?:

Repeater::make('items')
  ->schema([
    TextInput::make('user.name')
      ->label('Ordered by')
      ->disabled(),
]);

Repeater::make('items')
  ->schema([
    TextInput::make('user.name')
      ->label('Ordered by')
      ->disabled(),
]);

Repeater::make('items')
  ->schema([
    TextInput::make('user.name')
      ->label('Ordered by')
      ->disabled(),
]);

Repeater::make('items')
  ->schema([
    TextInput::make('user.name')
      ->label('Ordered by')
      ->disabled(),
]);

H

Hussain4real•1/7/24, 10:32 AM

another approach will be to use one of the layout component in the repeater

H

Hussain4real•1/7/24, 10:34 AM

return Repeater::make('items')
  ->schema([
Fieldset::make('user')
    ->relationship('user')
    ->schema([
      TextInput::make('user.name')
        ->label('Ordered by')
        ->disabled(),
  ])
]);

return Repeater::make('items')
  ->schema([
Fieldset::make('user')
    ->relationship('user')
    ->schema([
      TextInput::make('user.name')
        ->label('Ordered by')
        ->disabled(),
  ])
]);

return Repeater::make('items')
  ->schema([
Fieldset::make('user')
    ->relationship('user')
    ->schema([
      TextInput::make('user.name')
        ->label('Ordered by')
        ->disabled(),
  ])
]);

return Repeater::make('items')
  ->schema([
Fieldset::make('user')
    ->relationship('user')
    ->schema([
      TextInput::make('user.name')
        ->label('Ordered by')
        ->disabled(),
  ])
]);

H

Hussain4real•1/7/24, 10:35 AM

https://filamentphp.com/docs/3.x/panels/resources/relation-managers#choosing-the-right-tool-for-the-job

Managing relationships - Panel Builder - Filament

J

JJSandersOP•1/7/24, 10:47 AM

So Removing the relationship does not work.
Adding it as a Fieldset does work but it has affect on the layout of the repeater which is not desirable

H

Hussain4real•1/7/24, 10:48 AM

Fieldset is one of the layout component, is expected to change the layout.
you can try other layouts and see

J

JJSandersOP•1/7/24, 10:49 AM

But why does the relationship have effect on the layout?

H

Hussain4real•1/7/24, 10:52 AM

it's not the relationship but the Fieldset component

H

Hussain4real•1/7/24, 10:52 AM

you can try using inverseRelationship on the resource

J

JJSandersOP•1/7/24, 10:53 AM

Do you mean inverse relationship on the UserModel?

J

JJSandersOP•1/7/24, 10:53 AM

Because on the OrderItem i have a users relationship

H

Hussain4real•1/7/24, 10:53 AM

change it to inverse

H

Hussain4real•1/7/24, 10:54 AM

something like this:

protected static ?string $inverseRelationship = 'user';

protected static ?string $inverseRelationship = 'user';

protected static ?string $inverseRelationship = 'user';

protected static ?string $inverseRelationship = 'user';

H

Hussain4real•1/7/24, 10:54 AM

is it 'user' or 'users'

J

JJSandersOP•1/7/24, 10:54 AM

It is

user

user

user

user

H

Hussain4real•1/7/24, 10:55 AM

then in your repeater:

return Repeater::make('items')
  ->relationship('user)
  ->schema([
    TextInput::make('user.name')
      ->label('Ordered by')
      ->disabled(),
]);

return Repeater::make('items')
  ->relationship('user)
  ->schema([
    TextInput::make('user.name')
      ->label('Ordered by')
      ->disabled(),
]);

return Repeater::make('items')
  ->relationship('user)
  ->schema([
    TextInput::make('user.name')
      ->label('Ordered by')
      ->disabled(),
]);

return Repeater::make('items')
  ->relationship('user)
  ->schema([
    TextInput::make('user.name')
      ->label('Ordered by')
      ->disabled(),
]);

H

Hussain4real•1/7/24, 10:55 AM

make sure to comment out the

protected static string $relationship = 'user';

protected static string $relationship = 'user';

protected static string $relationship = 'user';

protected static string $relationship = 'user';

J

JJSandersOP•1/7/24, 10:58 AM

Filament\Forms\Components\Repeater::getRelationship(): Return value must be of type Illuminate\Database\Eloquent\Relations\HasOneOrMany|Illuminate\Database\Eloquent\Relations\BelongsToMany|null, Illuminate\Database\Eloquent\Relations\BelongsTo returned

Filament\Forms\Components\Repeater::getRelationship(): Return value must be of type Illuminate\Database\Eloquent\Relations\HasOneOrMany|Illuminate\Database\Eloquent\Relations\BelongsToMany|null, Illuminate\Database\Eloquent\Relations\BelongsTo returned

Filament\Forms\Components\Repeater::getRelationship(): Return value must be of type Illuminate\Database\Eloquent\Relations\HasOneOrMany|Illuminate\Database\Eloquent\Relations\BelongsToMany|null, Illuminate\Database\Eloquent\Relations\BelongsTo returned

Filament\Forms\Components\Repeater::getRelationship(): Return value must be of type Illuminate\Database\Eloquent\Relations\HasOneOrMany|Illuminate\Database\Eloquent\Relations\BelongsToMany|null, Illuminate\Database\Eloquent\Relations\BelongsTo returned

H

Hussain4real•1/7/24, 10:58 AM

though i'm not sure it's available for Model resource, according to the docs it's only usable in a relationship manager

H

Hussain4real•1/7/24, 11:02 AM

Have you tried using SelectInput inside the repeater?

H

Hussain4real•1/7/24, 11:03 AM

instead of TextInput it will be SelectInput
with relationship method

H

Hussain4real•1/7/24, 11:04 AM

https://filamentphp.com/docs/3.x/forms/fields/select#integrating-with-an-eloquent-relationship

Select - Form Builder - Filament

J

JJSandersOP•1/7/24, 11:26 AM

I'm away for a few hours. I will check later. Thanks for your help.

H

Hussain4real•1/7/24, 11:27 AM

my pleasure

Trying to show username but it is blank.

Similar Threads

Similar Threads

Similar Threads