Custom Filament Table with Query of Left Joined Tables

I have managed to create livewire component with filament table in it as described here:

https://filamentphp.com/docs/3.x/tables/adding-a-table-to-a-livewire-component

In the example, the query for the table is given for a single model. (Product::query())

How can I pass the query for the filament table so that it will take 2 joined tables?

SELECT * FROM employees LEFT JOIN attendances ON employees.id = attendances.employee_id

Adding a table to a Livewire component - Table Builder - Filament

Solution

Thanks, Dennis. I think I am getting somewhere. I tried as follow:

public function table(Table $table): Table
{
        return $table
            ->query(Employee::query()->leftJoin('attendances','employees.id','=','attendances.employee_id'))
            ->columns([
                TextColumn::make('first_name'), // column exists in Employee table and is showing
                TextColumn::make('result'), // column exists in Attendances table but is NOT showing
            ])...
}

public function table(Table $table): Table
{
        return $table
            ->query(Employee::query()->leftJoin('attendances','employees.id','=','attendances.employee_id'))
            ->columns([
                TextColumn::make('first_name'), // column exists in Employee table and is showing
                TextColumn::make('result'), // column exists in Attendances table but is NOT showing
            ])...
}

It seems to run correctly but the "result" column which supposes to get the data from the "attendances" table is not showing. Did I miss anything? Thanks!

Jump to solution

krekas•5/7/24, 5:38 AM

try using method

Kkrekas try using `modifyQueryUsing` method

setiawanhOP•5/7/24, 5:46 AM

Can you help with an example for the above SQL query? I cannot seem to find the documentation for this method on Filament Table

krekas•5/7/24, 5:47 AM

it's in different location

krekas•5/7/24, 5:48 AM

for example here https://filamentphp.com/docs/3.x/panels/resources/listing-records#customizing-the-table-eloquent-query

Listing records - Panel Builder - Filament

setiawanhOP•5/7/24, 5:52 AM

What should I put in the function body?

krekas•5/7/24, 5:56 AM

whatever you need to add to your query

setiawanhOP•5/7/24, 7:10 AM

table
->query(Employee::query())->modifyQueryUsing(fn (Builder $query) => $query->leftJoin(...))? Something like this?

Ssetiawanh table ->query(Employee::query())->modifyQueryUsing(fn (Builder $quer...

Dennis Koch•5/7/24, 8:48 AM

Yes

Dennis Koch•5/7/24, 8:48 AM

But when you provide already why don’t you put your query there?!

Solution

DDennis Koch But when you provide `->query()` already why don’t you put your query there?!

setiawanh•5/7/24, 9:01 AM

Thanks, Dennis. I think I am getting somewhere. I tried as follow:

public function table(Table $table): Table
{
        return $table
            ->query(Employee::query()->leftJoin('attendances','employees.id','=','attendances.employee_id'))
            ->columns([
                TextColumn::make('first_name'), // column exists in Employee table and is showing
                TextColumn::make('result'), // column exists in Attendances table but is NOT showing
            ])...
}

public function table(Table $table): Table
{
        return $table
            ->query(Employee::query()->leftJoin('attendances','employees.id','=','attendances.employee_id'))
            ->columns([
                TextColumn::make('first_name'), // column exists in Employee table and is showing
                TextColumn::make('result'), // column exists in Attendances table but is NOT showing
            ])...
}

It seems to run correctly but the "result" column which supposes to get the data from the "attendances" table is not showing. Did I miss anything? Thanks!

Ssetiawanh Thanks, Dennis. I think I am getting somewhere. I tried as follow: ```public fun...

Dennis Koch•5/7/24, 9:02 AM

Check what query is actually run and what it returns for example with Laravel Debugbar

setiawanhOP•5/7/24, 9:07 AM

Thanks! It is working now. There was a mistake in the "query" that I created.