SelectFilter unique/distinct relationship value

I have a table of tickets that belong to a location. Some locations are in the same city. How can I use a SelectFilter to get a unique list of cities from the locations table to filter the tickets? This is my code so far:

Tables\Filters\SelectFilter::make('location.city')
    ->label('City')
    ->placeholder('All')
    ->relationship('location', 'city')
    ->multiple()
    ->preload()
    ->searchable(),

Tables\Filters\SelectFilter::make('location.city')
    ->label('City')
    ->placeholder('All')
    ->relationship('location', 'city')
    ->multiple()
    ->preload()
    ->searchable(),

But this gives me a list of duplicated cities. I tried something like the following but unsuccessfully:

->relationship(
    'location',
    'city',
    fn (Builder $query): Builder => $query->distinct())

->relationship(
    'location',
    'city',
    fn (Builder $query): Builder => $query->distinct())

Not sure how to achieve this?

Filament•2y ago•

6 replies

morty

SelectFilter unique/distinct relationship value

Tables\Filters\SelectFilter::make('location.city')
    ->label('City')
    ->placeholder('All')
    ->relationship('location', 'city')
    ->multiple()
    ->preload()
    ->searchable(),

Tables\Filters\SelectFilter::make('location.city')
    ->label('City')
    ->placeholder('All')
    ->relationship('location', 'city')
    ->multiple()
    ->preload()
    ->searchable(),

But this gives me a list of duplicated cities. I tried something like the following but unsuccessfully:

->relationship(
    'location',
    'city',
    fn (Builder $query): Builder => $query->distinct())

->relationship(
    'location',
    'city',
    fn (Builder $query): Builder => $query->distinct())

Not sure how to achieve this?

SelectFilter unique/distinct relationship value

Similar Threads

SelectFilter unique/distinct relationship value

Similar Threads

Similar Threads

Similar Threads