What's wrong with $row on format not returning an element but the collection?

[emiliosh]

Hi, I feel like missing something from DataTables v1 to v2.

I have upgraded my Laravel 9 project from Datatables v1 to v2. And I had a custom Column with a tooltip method like this:

class Column extends \Rappasoft\LaravelLivewireTables\Views\Column
{
...
    public function tooltip($column_tooltip)
    {
        return $this->format(function ($value, $row, Column $column) use ($column_tooltip) {
            return view('livewire.table.tooltip')
                ->withValue($value)
                ->withTooltip(data_get($row, $column_tooltip));
        });
    }
}

I was accessing my item column used as tooltip with data_get (Laravel Helper).

This was working before but now I had realized that $row is returning a collection of my Model, i'm using public function builder(), not the single item.

Thanks in advance.

[lrljoe]

Can you expand slightly, share your builder() method, and what is being returned by $row please :)

Column::make('End Date', 'end_date')->format(fn($value, $row, Column $column) => dd($row))

Would return a single Model for that row (complete with any defined/included related model fields etc)

[emiliosh]

All right, I'm getting what's my problem.

I have a builder method like:

    public function builder(): Builder
    {
        $itemlist = Resolution::with(['employee', 'resolutiontype', 'motivestarted', 'motiveended']);

        if ($this->getCustomFilter('started_at')) {
            $fecha_ini = $this->getCustomFilter('started_at');
            $itemlist->whereDate('started_at', '>=', $fecha_ini);
        }
...
         return $itemlist;
     }

I realized the problem is that $row just got the attributes I have defined in my columns method. I really don't know where I found before it wasn't an element. Sorry for the mistake. Now I'm trying to solve this without using some Model::find('id')->relation->field. It's there anyway to attach more elements? I set $this->setEagerLoadAllRelationsEnabled(); but no solution. I just got the five columns as attributes in my $row.

More info. If I try this on my columns:

    public function columns(): array
    {
        return [
            Column::make(__('#'), 'id')
                ->sortable()
                ->excludeFromColumnSelect(),
            Column::make(__('#Empleado'), 'employee_id'),
            Column::make(__('Empleado'), 'employee.person.fullname')
                ->label(fn($row) => $row->employee->person->fullname),
            Column::make(__('Tipo N'), 'resolutiontype.name')->deselected(),
            Column::make(__('Tipo'), 'resolutiontype.code')
                ->format(function ($value, $row, Column $column) {
                    return view('livewire.table.tooltip')
                        ->withValue($value)
                        ->withTooltip($row->resolutiontype->name);
                }),
            Column::make(__('Motivo Ini'), 'motivestarted.code')
                ->tooltip('motivestarted.name'),
            Column::make(__('Motivo Fin'), 'motiveended.code')
                ->tooltip('motiveended.name'),
            Column::make(__('Ini'), 'started_at')
                ->sortable()
                ->formatDate(),
            Column::make(__('Fin'), 'ended_at')
                ->sortable()
                ->formatDate(),
        ];
    }

the $row->resolutiontype->name said I'm trying to access name on null relation.

[lrljoe]

What are the relationship types for those relations?

Noting that you're on v2, you may need to add the foreign keys in to setAdditionalSelects.

Moving to v3 does bring you up to livewire v3 support btw, not sure how much Livewire you've got elsewhere in your project tho

[emiliosh]

Yes I'm on v2.

This is resolutiontype relation at Resolution model.

  ...
   public function resolutiontype()
    {
        return $this->belongsTo(ResolutionType::class, 'resolutiontype_id');
    }
  ...

Finally I was able to make it work doing what you suggest.

public function configure: void
{
   ...
    $this->setAdditionalSelects('resolutiontypes.name as resolutiontypename');
   ...
}

And then in my column reference with:

            Column::make(__('Tipo'), 'resolutiontype.code')
                        ->tooltip('resolutiontypename'),

This was working before. Thanks.