Table optional relationship and sorting

Table is Units, field is

TextColumn::make('floorplans.bedroom_size')->sortable();

TextColumn::make('floorplans.bedroom_size')->sortable();

. Right now when I try to sort, Im getting

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'bedroom_size' in 'field list'

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'bedroom_size' in 'field list'

with

select * from `units` where (`archived` is null) and `units`.`tenant_id` = 1 order by (select `bedroom_size` from `floorplans` where `units`.`floorplan_id` = `floorplans`.`id` and `floorplans`.`deleted_at` is null) asc limit 10 offset 0

select * from `units` where (`archived` is null) and `units`.`tenant_id` = 1 order by (select `bedroom_size` from `floorplans` where `units`.`floorplan_id` = `floorplans`.`id` and `floorplans`.`deleted_at` is null) asc limit 10 offset 0

Filament•4y ago•

2 replies

Mark Chaney

Table optional relationship and sorting

Table is Units, field is

TextColumn::make('floorplans.bedroom_size')->sortable();

TextColumn::make('floorplans.bedroom_size')->sortable();

. Right now when I try to sort, Im getting

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'bedroom_size' in 'field list'

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'bedroom_size' in 'field list'

with

select * from `units` where (`archived` is null) and `units`.`tenant_id` = 1 order by (select `bedroom_size` from `floorplans` where `units`.`floorplan_id` = `floorplans`.`id` and `floorplans`.`deleted_at` is null) asc limit 10 offset 0

select * from `units` where (`archived` is null) and `units`.`tenant_id` = 1 order by (select `bedroom_size` from `floorplans` where `units`.`floorplan_id` = `floorplans`.`id` and `floorplans`.`deleted_at` is null) asc limit 10 offset 0

Table optional relationship and sorting

Similar Threads

Table optional relationship and sorting

Similar Threads

Similar Threads

Similar Threads