F
Filament•2mo ago
yaroslavpopovic

TextColumn with nested relationships - How to display unique values?

Hi everyone! 👋 I'm working with a TextColumn that displays data from a nested relationship (MorphMany → BelongsToMany), and I need to show unique user names. My setup: - P2pStaffProcessInstance has organizationalActivities() (MorphMany) - P2pProcessActivity has users() (BelongsToMany) Current code: 
TextColumn::make('organizationalActivities.users.name')
    ->label('Consultants'),
php
TextColumn::make('organizationalActivities.users.name')
    ->label('Consultants'),
php
This displays all user names separated by commas, but the same user can appear multiple times if they're assigned to different activities. What I need: Display unique user names (no duplicates) in the column. What I've tried: 
->formatStateUsing(function ($record) {
    return $record->organizationalActivities
        ->pluck('users')
        ->flatten()
        ->unique('id')
        ->pluck('name')
        ->join(', ');
})
php
->formatStateUsing(function ($record) {
    return $record->organizationalActivities
        ->pluck('users')
        ->flatten()
        ->unique('id')
        ->pluck('name')
        ->join(', ');
})
php
But it still shows duplicate names. Any suggestions on the best way to handle this? Thanks! 🙏
Solution:
fix with: TextColumn::make('organizationalActivities.users.name') ->distinctList() ->searchable() ->sortable()...
Jump to solution
1 Reply
Solution
yaroslavpopovic
yaroslavpopovic•2mo ago
fix with: TextColumn::make('organizationalActivities.users.name') ->distinctList() ->searchable() ->sortable()

Did you find this page helpful?