Filtering by a related table column changes the table id

Hi, I'm following the Owners, Pets, Treatments demo and I'm having issues creating a simple toggle filter by owner's email for the Patients resource.

Tables\Filters\Filter::make('owner_email')
    ->label('Owner email is John Doe')
    ->toggle()
    ->baseQuery(function (Builder $query): Builder {
        return $query
            ->join('owners', 'patients.owner_id', '=', 'owners.id');
    })
    ->query(function (Builder $query): Builder {
        return $query
            ->where('owners.email', '=', 'john@doe.com');
    }),

Tables\Filters\Filter::make('owner_email')
    ->label('Owner email is John Doe')
    ->toggle()
    ->baseQuery(function (Builder $query): Builder {
        return $query
            ->join('owners', 'patients.owner_id', '=', 'owners.id');
    })
    ->query(function (Builder $query): Builder {
        return $query
            ->where('owners.email', '=', 'john@doe.com');
    }),

My problem is that after applying filter, the Patients table now uses the owner's id instead of the patients id. What I'm doing wrong?

Solution

You are adding a join with a table that also has an ID. Try adding a

select('your_table.*')

select('your_table.*')

via the table query

Jump to solution

Filament•3y ago•

9 replies

Miguel García

Filtering by a related table column changes the table id

Hi, I'm following the Owners, Pets, Treatments demo and I'm having issues creating a simple toggle filter by owner's email for the Patients resource.

Tables\Filters\Filter::make('owner_email')
    ->label('Owner email is John Doe')
    ->toggle()
    ->baseQuery(function (Builder $query): Builder {
        return $query
            ->join('owners', 'patients.owner_id', '=', 'owners.id');
    })
    ->query(function (Builder $query): Builder {
        return $query
            ->where('owners.email', '=', 'john@doe.com');
    }),

Tables\Filters\Filter::make('owner_email')
    ->label('Owner email is John Doe')
    ->toggle()
    ->baseQuery(function (Builder $query): Builder {
        return $query
            ->join('owners', 'patients.owner_id', '=', 'owners.id');
    })
    ->query(function (Builder $query): Builder {
        return $query
            ->where('owners.email', '=', 'john@doe.com');
    }),

My problem is that after applying filter, the Patients table now uses the owner's id instead of the patients id. What I'm doing wrong?

Solution

You are adding a join with a table that also has an ID. Try adding a

select('your_table.*')

select('your_table.*')

via the table query

Jump to solution

Filtering by a related table column changes the table id

Filtering by a related table column changes the table id

Similar Threads

Similar Threads

Similar Threads