How to get role name

[luis9430]

Hi, I'm using the roles spatie package, I'm trying to get the role name for each user, how should I do it?

in datasource I have this

but it returns an array with all the data

I hope you can help me, thanks

[dansysanalyst]

Hi Luis,

I am not sure if this is the best approach, I believe it's not enough for filtering by the relationship for example.

I have never used Spatie Roles, but I had a go with it:

    public function datasource(): ?Builder
    {
        return User::query()->with('roles');
    }

It's unclear to me if a user can have multiple roles.

Add($user->roles) shows me:

So, I follow this relationship, plucking the Roles names and joining them together by ",".

    public function addColumns(): ?PowerGridEloquent
    {
        return PowerGrid::eloquent()
            ->addColumn('id')
            ->addColumn('last_name')
            ->addColumn('role_name', function (User $user) {
                return $user->roles
                    ->pluck('name')
                    ->implode(',');
            });
    }

And I get:

@luanfreitasdev a better idea would be to Join table?

https://livewire-powergrid.com/#/table/datasource?id=join-tables

[luis9430]

hello, thank you very much for your answer, I tried it and it worked
and yes, users can have multiple roles that returns an array...
and about filtering the information I will investigate how it can be done, thanks!

[LinceIberico]

Hello everyone, have you found anything else? I have the same problem and I can't find the solution. I can't get role filtering to work.

With this function the roles appear but it does not filter either, the error is always the same because it makes a sql query in the filters.
->makeInputSelect(Role::all(),'name','id', ['live-search' => true]),