Filament•2y ago•

1 reply

How to hide null relationships on table

I have a

Table

Table

showing

Applications

Applications

for

Vacancies

Vacancies

(

Vacancies

Vacancies

HasMany

HasMany

Applications

Applications

and

Applications

Applications

BelongsTo

BelongsTo

Vacancy

Vacancy

). When

Vacancies

Vacancies

are deleted, any

Applications

Applications

have their relation set to

null

null

- this is so the person posting a

Vacancy

Vacancy

can’t delete an

Application

Application

by another user.

I want to try two things:

First idea, how do I filter

Applications

Applications

will a

null

null

Vacancy

Vacancy

relation? Here’s my current code for show all

Applications

Applications

and their

Vacancy

Vacancy

// ApplicationResource
$table
->columns([
    Tables\Columns\TextColumn::make('title')
        ->searchable(),
    Tables\Columns\TextColumn::make('vacancy.title')
        ->url(fn (Application $application): string => VacancyResource::getUrl('edit', ['record' => $application->vacancy_id])),
    Tables\Columns\TextColumn::make('created_at')
        ->label('Received')
        ->dateTime(),
])
...

// ApplicationResource
$table
->columns([
    Tables\Columns\TextColumn::make('title')
        ->searchable(),
    Tables\Columns\TextColumn::make('vacancy.title')
        ->url(fn (Application $application): string => VacancyResource::getUrl('edit', ['record' => $application->vacancy_id])),
    Tables\Columns\TextColumn::make('created_at')
        ->label('Received')
        ->dateTime(),
])
...

Second idea - how can I display ‘Deleted vacancy’ if the relationship is

null

null

How to hide null relationships on table

I have a

Table

Table

showing

Applications

Applications

for

Vacancies

Vacancies

(

Vacancies

Vacancies

HasMany

HasMany

Applications

Applications

and

Applications

Applications

BelongsTo

BelongsTo

Vacancy

Vacancy

). When

Vacancies

Vacancies

are deleted, any

Applications

Applications

have their relation set to

null

null

- this is so the person posting a

Vacancy

Vacancy

can’t delete an

Application

Application

by another user.

I want to try two things:

First idea, how do I filter

Applications

Applications

will a

null

null

Vacancy

Vacancy

relation? Here’s my current code for show all

Applications

Applications

and their

Vacancy

Vacancy

// ApplicationResource
$table
->columns([
    Tables\Columns\TextColumn::make('title')
        ->searchable(),
    Tables\Columns\TextColumn::make('vacancy.title')
        ->url(fn (Application $application): string => VacancyResource::getUrl('edit', ['record' => $application->vacancy_id])),
    Tables\Columns\TextColumn::make('created_at')
        ->label('Received')
        ->dateTime(),
])
...

// ApplicationResource
$table
->columns([
    Tables\Columns\TextColumn::make('title')
        ->searchable(),
    Tables\Columns\TextColumn::make('vacancy.title')
        ->url(fn (Application $application): string => VacancyResource::getUrl('edit', ['record' => $application->vacancy_id])),
    Tables\Columns\TextColumn::make('created_at')
        ->label('Received')
        ->dateTime(),
])
...

Second idea - how can I display ‘Deleted vacancy’ if the relationship is

null

null

How to hide null relationships on table

Similar Threads

How to hide null relationships on table

Similar Threads

Similar Threads

Similar Threads