How to load specific model data into Table Builder?

I have a Model UserTracking that has the column user_id and here a one to one relationship exists. In the Table Builder I would now like to display the user name instead of the ID and if possible also load a model function as value. Is this possible? I didn't found a solution in the docs

eazy•8/17/23, 12:21 PM

TextColumn::make('user.name')

TextColumn::make('user.name')

eazy•8/17/23, 12:21 PM

Or whatever your relation is called and the name is called on the model

eazy•8/17/23, 12:22 PM

Also if the function is a attribute you can call it the same way with the attribute name

slamx_OP•8/17/23, 12:50 PM

@eazyurk thanks, but when I try to call a model function, I get the following error:
App\Models\User::getUserDisplayName must return a relationship instance any Idea to fix this?

eazy•8/17/23, 12:51 PM

yeah

eazy•8/17/23, 12:53 PM

On the User model add a custom accessor for the display name like in the docs:
https://laravel.com/docs/10.x/eloquent-mutators#defining-an-accessor
propably something like this:

    protected function displayName(): Attribute
    {
        return Attribute::make(
            get: fn () => "$this->name $this->last_name",
        );
    }

    protected function displayName(): Attribute
    {
        return Attribute::make(
            get: fn () => "$this->name $this->last_name",
        );
    }

(or something like that)
Then in your textcolumn you can do this:

TextColumn::make('user.display_name')

TextColumn::make('user.display_name')

slamx_OP•8/17/23, 1:41 PM

Many thanks!

How to load specific model data into Table Builder?

Similar Threads

Similar Threads

Similar Threads