Filament•2mo ago

How to eager load relationship inside infolist repeatable entry

I've enable prevent lazy loading like this in providers Model::preventLazyLoading(! $this->app->isProduction()); I create a relationship manager and I display the data in infolist. but when it comes to repeatable entry like below example, I always got this error Attempted to lazy load [customer] on model [App\Models\Reply] but lazy loading is disabled.

protected static string $relationship = 'comments';

public function infolist(Infolist $infolist): Infolist
{
    return $infolist
        ->schema([
            // ...

            Infolists\Components\RepeatableEntry::make('replies')
                ->schema([
                    Infolists\Components\TextEntry::make('customer.name'),
                ]),
        ]);
}

// Comment model
public function replies(): HasMany
{
    return $this->hasMany(Reply::class);
}

// Reply model
public function customer(): BelongsTo
{
    return $this->belongsTo(Customer::class);
}

protected static string $relationship = 'comments';

public function infolist(Infolist $infolist): Infolist
{
    return $infolist
        ->schema([
            // ...

            Infolists\Components\RepeatableEntry::make('replies')
                ->schema([
                    Infolists\Components\TextEntry::make('customer.name'),
                ]),
        ]);
}

// Comment model
public function replies(): HasMany
{
    return $this->hasMany(Reply::class);
}

// Reply model
public function customer(): BelongsTo
{
    return $this->belongsTo(Customer::class);
}

I can put protected $with = ['customer']; inside Model, but it's not a great solution IMO, so what should be the best way to eager load the relationship

Solution:

Yes, so helpful.. Now I use ->modifyQueryUsing() and load relationship. it's working now, thanks

Jump to solution

19 Replies

Jigar D•2mo ago

Does this help? https://www.answeroverflow.com/m/1110666450349326446

How to eager load in Relation Manager? - Filament

Hey guys, I am trying to optimise my app. So I used this: Model::shouldBeStrict(app()->isLocal()); I found one problem in my RelationManager. I have User that has many Clients and he belongs to Address. When I want to edit User I got this error: https://flareapp.io/share/dPbNO6LP#F129

Solution

Vp•2mo ago

Yes, so helpful.. Now I use ->modifyQueryUsing() and load relationship. it's working now, thanks

mark.cameron•2mo ago

@Vp Where did you put the ->modifyQueryUsing() ? I get a method doesn't exist on the Infolist when I try it like this:

return $infolist
    ->modifyQueryUsing(...)
    ->schema([

return $infolist
    ->modifyQueryUsing(...)
    ->schema([

It only appears to work on $table, but that has no effect on ths Infolist display when viewing the model... Thanks for your help!

Vp•2mo ago

I put in $table and I just use it inside infolist Example:

return $table
    ->modifyQueryUsing(fn ($query) => $query->with([
        'replies' => fn ($reply) => $reply->with('parent'),
    ]))
    ...

return $infolist
    ->schema([
        Infolists\Components\RepeatableEntry::make('replies')
            ->schema([
                Infolists\Components\TextEntry::make('parent.name),

return $table
    ->modifyQueryUsing(fn ($query) => $query->with([
        'replies' => fn ($reply) => $reply->with('parent'),
    ]))
    ...

return $infolist
    ->schema([
        Infolists\Components\RepeatableEntry::make('replies')
            ->schema([
                Infolists\Components\TextEntry::make('parent.name),

mark.cameron•2mo ago

Ok thanks for the example, but I still get the but lazy loading is disabled message for the relationship that I define in the modifyQueryUsing(). Not sure what I am missing... But even debugging the modifyQueryUsing(), and I'm not passing through it when on the Infolist...

Vp•2mo ago

can you share some codes in which part it shows lazy load disabled?

mark.cameron•2mo ago

It's all vendor stuff

mark.cameron•2mo ago

This is the code for the table() and infolist() methods on the resource

message.txt

mark.cameron•2mo ago

My relation is the contactables one and using the with('contact')

Vp•2mo ago

I am not sure but below part maybe the suspect, what is this $record contains? It looks like it's not load relationship. for me I just use normal ViewAction

->recordUrl(
    fn (News $record): string => route(static::getRouteBaseName() . '.view', [
        'record' => $record,
        'tenant' => Filament::getTenant()
    ]),
);

->recordUrl(
    fn (News $record): string => route(static::getRouteBaseName() . '.view', [
        'record' => $record,
        'tenant' => Filament::getTenant()
    ]),
);

mark.cameron•2mo ago

ahh, is yours in a modal ?

Vp•2mo ago

wdym?

mark.cameron•2mo ago

As in, is yours a simple resource? And when you click on view, it display the resource in a Modal, and not on it's own page?

Vp•2mo ago

Yes, only modal.. I use slideOver() as well 😆 If you use full page (own page) then I think you need to load realtionship on that page

mark.cameron•2mo ago

Ok that might explain it, as I'm on a new page the relationship query isn't called from the $table... Ok thanks I'll have a look there

Vp•2mo ago

🆒

mark.cameron•2mo ago

Thanks for your help!

Vp•2mo ago

mark.cameron•2mo ago

For future visitors: You can do something like this to eager load the relationship on the "View" page for your resource by overriding the mount() method, might be other ways or cleaner ways, but I couldn't see any other way to interact with the query:

<?php

...

class ViewNews extends ViewRecord
{
    protected static string $resource = NewsResource::class;

    #[\Override]
    public function mount(int | string $record): void
    {
        parent::mount($record);

        $this->record->load('contactables.contact', 'contactables.category');
    }

    ...
}

<?php

...

class ViewNews extends ViewRecord
{
    protected static string $resource = NewsResource::class;

    #[\Override]
    public function mount(int | string $record): void
    {
        parent::mount($record);

        $this->record->load('contactables.contact', 'contactables.category');
    }

    ...
}

Gaming

Programming

How to eager load relationship inside infolist repeatable entry