How can I display json data in a table

[yablochnyi]

Package

Table builder

Package Version

v3

How can we help you?

Hi, there is a market_position field in the table. It stores json
[{"symbol":"BTCUSDT","side":"long/short","price":"40000.00","lots":"1.00","notional":"40000.00","unpl":"1.00"}]
How can I display symbol in the table?
`public function table(Table $table): Table
{

    return $table
        ->query(UserStatistic::query()->where('account', $this->statistic->serial_number_user))
        ->columns([
            TextColumn::make('market_positions.symbol')
                ->label('Symbol')

        ]);
}`

[leandrocfe]

If you are using market_positions.symbol, the column value should be

{
    "symbol": "BTCUSDT",
    "side": "long/short",
    "price": "40000.00",
    "lots": "1.00",
    "notional": "40000.00",
    "unpl": "1.00"
}

without "[]"

[Max-Lovell]

could do a custom view saved in resources/views/filament/tables/columns/json.blade.php:

@foreach($getState() as $variable => $value)
    <p>
        {{$variable}}={{$value}}@if(!$loop->last),@endif&nbsp;
    </p>
@endforeach

and call it in the filament page

ViewColumn::make('json data col')
    ->view('filament.tables.columns.json')
    ->searchable()
    ->sortable(),

[Benyaminrmb]

its good but how can we add toggledHiddenByDefault() in this ViewColumn?
cuz its not work

[Benyaminrmb]

->toggleable(isToggledHiddenByDefault: true) my bad . ty for ViewColumn

[emmanpbarrameda]

json value:
[{"deceased_name":"emmans","deceased_birthdate":"2015-12-04","deceased_age":9,"deceased_deathdate":"2024-12-26","deceased_gender":"1"},{"deceased_name":"test test test","deceased_birthdate":"2013-12-20","deceased_age":11,"deceased_deathdate":"2024-12-19","deceased_gender":"2"}]

display json data on table textcolumn:

                //?
                Tables\Columns\TextColumn::make('wake_services_repeatable_info')
                    ->label('Deceased Name')
                    ->getStateUsing(function ($record) {
                        if (!$record->wake_services_repeatable_info) return null;
                        
                        return collect($record->wake_services_repeatable_info)
                            ->pluck('deceased_name')
                            ->filter()
                            ->join(', ');
                    })
                    ->searchable(query: function (Builder $query, string $search) {
                        return $query->whereJsonContains('wake_services_repeatable_info', ['deceased_name' => $search]);
                    }),