Filament•3mo ago

Order TextColumn relationship results by desc

this might be an easy thing but I can't find a way to do it 😅 as shown in the screenshot, I have a TextColumn that loads results from a relationship. So there might be multiple years. I would like to order them by desc, so that the latest year appears as first. How do I do that?

Tables\Columns\TextColumn::make('subscriptions.subscriptionYear.year')
    ->label('Iscrizioni')
    ->searchable()
    ->listWithLineBreaks()
    ->limitList(1)
    ->expandableLimitedList(),

Tables\Columns\TextColumn::make('subscriptions.subscriptionYear.year')
    ->label('Iscrizioni')
    ->searchable()
    ->listWithLineBreaks()
    ->limitList(1)
    ->expandableLimitedList(),

26 Replies

Vp•3mo ago

Easiest way will be orderBy() in relationship itself imo

Vp•3mo ago

otherwise you need to do like this https://filamentphp.com/docs/3.x/tables/columns/text#custom-formatting and return order data

Text column - Table Builder - Filament

zemo•3mo ago

like this? I did try that but it doesn't work

public function subscriptionYear(): BelongsTo
    {
        return $this->belongsTo(SubscriptionYear::class)->orderBy('year', 'desc');
    }

public function subscriptionYear(): BelongsTo
    {
        return $this->belongsTo(SubscriptionYear::class)->orderBy('year', 'desc');
    }

I will look into the other thing you recommended me, thank you!

Vp•3mo ago

yeah this is what i have in mind, don't know why it not works 😆

zemo•3mo ago

I did try this but it seems it only works on the single instance, there isn't a way to work on all of them (the array of instances)

micraux•3mo ago

Hi, Maybe by customizing the query?

$table
    ->modifyQueryUsing(function (Builder $query) {
        $query->orderBy(...)
    })

$table
    ->modifyQueryUsing(function (Builder $query) {
        $query->orderBy(...)
    })

zemo•3mo ago

"Method Filament\Tables\Columns\TextColumn::modifyQueryUsing does not exist." I think that modifyQueryUsing can only be used as a parameter when you call the relationship() method, but TextColumn doesn't have that option

micraux•3mo ago

Not in the textColumn! Read again, the first line: $table Oh, forget it, you don't want to reorder the table, my bad...

Vp•3mo ago

Im on mobile rn, cannot check the code.. but what if you exclude .year in make()? By default filament displays all, so it should give arrays in somehow

micraux•3mo ago

I just tried VP's solution and it works: you can add an orderBy() in your BelongsToMany() relation. Can you show your Resource code (especially the relation)?

zemo•3mo ago

yes, I really don't understand why it's not working 😅 even debugbar is showing the correct query, but the results are not actually ordered:

select * from `subscription_years` where `subscription_years`.`id` in (1, 2, 6) order by `year` desc

select * from `subscription_years` where `subscription_years`.`id` in (1, 2, 6) order by `year` desc

this is the relationship, in Subscription.php:

public function subscriptionYear(): BelongsTo
    {
        return $this->belongsTo(SubscriptionYear::class)->orderBy('year', 'desc');
    }

public function subscriptionYear(): BelongsTo
    {
        return $this->belongsTo(SubscriptionYear::class)->orderBy('year', 'desc');
    }

micraux•3mo ago

So, try to call only the relation and the field, like this: Tables\Columns\TextColumn::make('subscriptionYear.year')

zemo•3mo ago

forgot to mention, I'm in a resource called subject, which has an HasMany relationship called subscriptions, which has a BelongsTo relationship called subscriptionYear that's why I'm calling both no luck with that either only thing I can think of is that it is not working cos it's a nested relationship

LeandroFerreira•3mo ago

Could you share the subscriptions relationship? Did you try ->orderByDesc('year') in the subscription relationship?

zemo•3mo ago

in Subject.php

    public function subscriptions()
    {
        return $this->hasMany(Subscription::class);
    }

    public function subscriptions()
    {
        return $this->hasMany(Subscription::class);
    }

just tried what you suggested and the result is the same, it doesn't work even if debugbar shows the correct query in Subscription.php

     public function subscriptionYear(): BelongsTo
    {
        return $this->belongsTo(SubscriptionYear::class)->orderByDesc('year');
    }

     public function subscriptionYear(): BelongsTo
    {
        return $this->belongsTo(SubscriptionYear::class)->orderByDesc('year');
    }

Gaming

Programming

Order TextColumn relationship results by desc