Display json data as columns

[WojciechRhdt]

I have a model where data is stored as a json object in the database. Is there a way to programmatically add this data to the table as its own columns?

I know how to add this data as own columns by using the format() function (see the following code snippet), but not how to do it programmatically to add the json data as own colums.

Does anyone have any ideas?

[lrljoe]

High level!
Amend your columns() function, and create an array for your initial columns instead of just returning an array.
After setting that initial array, do your foreach(json_decode()), and add a new Column instance to the array for each item.
Then return the array at the end.

So it'll look something like the below.

  /**
   * @return array<mixed>
   */
  public function columns(): array
  {
      $cols = [
          Column::make('Name', 'name')
              ->sortable()
              ->searchable(),
   ];
   // Do your foreach to setup the Column Names, and label values here, and append to $cols[]
 return $cols;
 }

[WojciechRhdt]

Thanks for the hint! I found a soulution:

`
public function columns(): array {

 $columns = [
        Column::make(__("ID"), "id")
            ->searchable(),

        Column::make(__("form"), "form_id")
            ->searchable(),      
    ];

 
    if (isset($this->data)) {
        foreach ($this->data as $key => $value) {
                array_push($columns, Column::make(__($key), "data->".$key)
                ->searchable());
        }
    }

    return $columns;
}`