Filament•3y ago•

2 replies

Table column loses data when sorting by relationship

Arjen · 2024-01-25T08:17:17.045Z

I have the following relation `Booking` -> HasMany -> `Dayparts` where `Dayparts` has a field `date`. I want to sort courses by the first child in `Dayparts` and while the code for that sorts the items in the table correctly, the data in the sorted column in the table just disappears. When the table is not sorted, the date is showing correctly. Any idea what I'm doing wrong? This is the table column in the `BookingResource`: ```php Tables\Columns\TextColumn::make('dayparts.0.date') ->label('Datum') ->date('d-m-Y') ->sortable( query: fn ($query, $direction) => $query ->join('dayparts', function ($join) { $join->on('dayparts.booking_id', '=', 'bookings.id') ->on('dayparts.id', DB::raw("(SELECT min(id) FROM dayparts WHERE dayparts.booking_id = bookings.id)")); }) ->orderBy('date', $direction) ), ``` I tried changing `'dayparts.0.date'` to `'date'` as well, but that changes nothing.

I have the following relation

Booking

Booking

-> HasMany ->

Dayparts

Dayparts

where

Dayparts

Dayparts

has a field

date

date

. I want to sort courses by the first child in

Dayparts

Dayparts

and while the code for that sorts the items in the table correctly, the data in the sorted column in the table just disappears. When the table is not sorted, the date is showing correctly. Any idea what I'm doing wrong? This is the table column in the

BookingResource

BookingResource

Tables\Columns\TextColumn::make('dayparts.0.date')
    ->label('Datum')
    ->date('d-m-Y')
    ->sortable(
        query: fn ($query, $direction) => $query
            ->join('dayparts', function ($join) {
                $join->on('dayparts.booking_id', '=', 'bookings.id')
                    ->on('dayparts.id', DB::raw("(SELECT min(id) FROM dayparts WHERE dayparts.booking_id = bookings.id)"));
            })
            ->orderBy('date', $direction)
    ),

Tables\Columns\TextColumn::make('dayparts.0.date')
    ->label('Datum')
    ->date('d-m-Y')
    ->sortable(
        query: fn ($query, $direction) => $query
            ->join('dayparts', function ($join) {
                $join->on('dayparts.booking_id', '=', 'bookings.id')
                    ->on('dayparts.id', DB::raw("(SELECT min(id) FROM dayparts WHERE dayparts.booking_id = bookings.id)"));
            })
            ->orderBy('date', $direction)
    ),

I tried changing

'dayparts.0.date'

'dayparts.0.date'

'date'

'date'

as well, but that changes nothing.

Table column loses data when sorting by relationship

I have the following relation

Booking

Booking

-> HasMany ->

Dayparts

Dayparts

where

Dayparts

Dayparts

has a field

date

date

. I want to sort courses by the first child in

Dayparts

Dayparts

BookingResource

BookingResource

Tables\Columns\TextColumn::make('dayparts.0.date')
    ->label('Datum')
    ->date('d-m-Y')
    ->sortable(
        query: fn ($query, $direction) => $query
            ->join('dayparts', function ($join) {
                $join->on('dayparts.booking_id', '=', 'bookings.id')
                    ->on('dayparts.id', DB::raw("(SELECT min(id) FROM dayparts WHERE dayparts.booking_id = bookings.id)"));
            })
            ->orderBy('date', $direction)
    ),

Tables\Columns\TextColumn::make('dayparts.0.date')
    ->label('Datum')
    ->date('d-m-Y')
    ->sortable(
        query: fn ($query, $direction) => $query
            ->join('dayparts', function ($join) {
                $join->on('dayparts.booking_id', '=', 'bookings.id')
                    ->on('dayparts.id', DB::raw("(SELECT min(id) FROM dayparts WHERE dayparts.booking_id = bookings.id)"));
            })
            ->orderBy('date', $direction)
    ),

I tried changing

'dayparts.0.date'

'dayparts.0.date'

'date'

'date'

as well, but that changes nothing.

Table column loses data when sorting by relationship

Similar Threads

Table column loses data when sorting by relationship

Similar Threads

Similar Threads

Similar Threads