Relational sorting issue

[vntrungld]

I have 2 tables: users and activities. Both has the name field.

My grid function of ActivityController looks like this:

protected function grid()
{
    return Admin::grid(Activity::class, function (Grid $grid) {

        $grid->id('ID')->sortable();
        $grid->column('user.username', 'Owner')->sortable();
        $grid->column('name')->sortable();

        $grid->created_at();
        $grid->updated_at();
    });
}

When I sort by name it works fine

But when I sort by Owner the name field replaced by name of the Owner

Is there anyone has this problem?

[freecod]

Problem exists and from here:

laravel-admin/src/Grid/Model.php

Line 540 in 1320bf4

$this->queries->push([

Before this code need add

            $this->queries->push([
                'method'    => 'select',
                'arguments' => [$this->model->getTable() . ".*"],
            ]);

its fix set equal fields from relation to eloquent model.

[z-song]

pr merged, Thanks!