Filament•7mo ago

Large json columns

I have a table with some large json columns and it's slowing down a resource table from loading and I don't show them on the table. How do I exclude those columns from the resource query?

4 Replies

harps•7mo ago

I think I worked this out, rather than exclude I need to modify the table query to only include what aI want.

           ->modifyQueryUsing(fn (Builder $query) =>  $query->select(
                'id',
                'type',
                'asset_label',
                'start_point',
                'status',
                'batch_id',
                'assigned_to_id',
                'region',
                'created_at',
                'exported',
            ));

           ->modifyQueryUsing(fn (Builder $query) =>  $query->select(
                'id',
                'type',
                'asset_label',
                'start_point',
                'status',
                'batch_id',
                'assigned_to_id',
                'region',
                'created_at',
                'exported',
            ));

toeknee•7mo ago

I would say that's good, but maybe look to loop through the columns within the schema that are visible and just render them. As the above is more overhead if you add a column in 6 months and forget.

harps•7mo ago

Hi @toeknee, These are the only fields I need in the table. Which form are you referring to? In my case it was actually better to create a global scope as I only needed the json objects at very specific points in the application such as viewing a resource.

toeknee•7mo ago

Perfect

Gaming

Programming

Large json columns