public function table(Table $table): Table
{
return $table
->query(InventoryLocation::query()->with([
'userLocations' => function ($query) {
$query->latest()
->take(1);
},
]))
->columns([
TextColumn::make('name')
->getStateUsing(fn ($record) => $record->userLocations?->first()->data['name'] ?? $record->name)
->label('Location Name')
->searchable(query: function ($query, $search) {
$query->where('name', 'like', "%{$search}%");
})
->sortable(),
public function table(Table $table): Table
{
return $table
->query(InventoryLocation::query()->with([
'userLocations' => function ($query) {
$query->latest()
->take(1);
},
]))
->columns([
TextColumn::make('name')
->getStateUsing(fn ($record) => $record->userLocations?->first()->data['name'] ?? $record->name)
->label('Location Name')
->searchable(query: function ($query, $search) {
$query->where('name', 'like', "%{$search}%");
})
->sortable(),