Filament•13mo 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

harpsOP•13mo 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•13mo 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.

harpsOP•13mo 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•13mo ago

Perfect

Gaming

Programming

Large json columns