F
Filament•2mo ago
jak888

display null values as 'null'

I have a table widget, where I want to display unconfirmed users. How can I display the string 'null' in the 'email_verified_at' column, when it's null? Here's what I have so far: 
namespace App\Filament\Widgets;

use App\Filament\Resources\UserResource;
use Filament\Tables\Actions\EditAction;
use Filament\Tables\Columns\TextColumn;
use Filament\Tables\Filters\Filter;
use Illuminate\Database\Eloquent\Builder;
use Filament\Tables\Table;
use Filament\Widgets\TableWidget as BaseWidget;

class LatestUsers extends BaseWidget
{
    protected int|string|array $columnSpan = 'full';
    protected static ?int $sort = 1;

    public function table(Table $table): Table
    {
        return $table
            ->query(
                UserResource::getEloquentQuery()
            )
            ->defaultPaginationPageOption(5)
            ->defaultSort('created_at', 'desc')
            ->columns([
                TextColumn::make('created_at'),
                TextColumn::make('name')
                    ->searchable()
                    ->sortable(),
                TextColumn::make('email')
                    ->searchable()
                    ->sortable(),
                TextColumn::make('email_verified_at')
                    ->label('Confirmed?')
                    ->formatStateUsing(fn(string $value): string => $value ? $value : 'null'), // <--- How do display null as a 'null'
            ])
            ->filters([
                Filter::make('email_verified_at')
                    ->label('Unconfirmed Users')
                    ->default(true)
                    ->query(fn(Builder $query): Builder => $query->whereNull('email_verified_at'))
            ])
            ->actions([
                EditAction::make(),
            ]);
    }
}
namespace App\Filament\Widgets;

use App\Filament\Resources\UserResource;
use Filament\Tables\Actions\EditAction;
use Filament\Tables\Columns\TextColumn;
use Filament\Tables\Filters\Filter;
use Illuminate\Database\Eloquent\Builder;
use Filament\Tables\Table;
use Filament\Widgets\TableWidget as BaseWidget;

class LatestUsers extends BaseWidget
{
    protected int|string|array $columnSpan = 'full';
    protected static ?int $sort = 1;

    public function table(Table $table): Table
    {
        return $table
            ->query(
                UserResource::getEloquentQuery()
            )
            ->defaultPaginationPageOption(5)
            ->defaultSort('created_at', 'desc')
            ->columns([
                TextColumn::make('created_at'),
                TextColumn::make('name')
                    ->searchable()
                    ->sortable(),
                TextColumn::make('email')
                    ->searchable()
                    ->sortable(),
                TextColumn::make('email_verified_at')
                    ->label('Confirmed?')
                    ->formatStateUsing(fn(string $value): string => $value ? $value : 'null'), // <--- How do display null as a 'null'
            ])
            ->filters([
                Filter::make('email_verified_at')
                    ->label('Unconfirmed Users')
                    ->default(true)
                    ->query(fn(Builder $query): Builder => $query->whereNull('email_verified_at'))
            ])
            ->actions([
                EditAction::make(),
            ]);
    }
}
6 Replies
dissto
dissto•2mo ago
You could probably just use the ->placeholder('null') as it will be used when the value is null so you don't really need the formatStateUsing 🤔
jak888
jak888•2mo ago
@dissto This is of course correct! I guess I'll have to wait a bit longer to figure out, what formatStateUsing does... Thank you!
dissto
dissto•2mo ago
@jak888 there is nothing wrong with using formatStateUsing you probably just had a slight hickup with the passed parameter. I dont think $value will work though, so you would need $state or $record. As stated in the docs So something like that would also work. Its up to you if you prefer the extra step 😋 
->formatStateUsing(function (string $state) {
    return filled($state) ? $state : 'null';
})
->formatStateUsing(function (string $state) {
    return filled($state) ? $state : 'null';
})
jak888
jak888•2mo ago
That's where I got confused (and why even my more simpler tries didn't work). Correct me if I'm wrong, but javascript would not care what you call your parameter?
dissto
dissto•2mo ago
i think you are right. Im not too knowledgeable about js though 😊
jak888
jak888•2mo ago
OK, then Thanks a bunch!
Want results from more Discord servers?
Add your server
More Posts
Show a list of options based on another fieldHello devs, how can I show a list of options with Select based on another select element? ```SelectValidating Signed Route RequestsWhen using filament forms on a livewire component and submitted, how do we verify that the request hHow can the resource query be modified on an Infolist page?Hi, When loading a resource, the standard `select` uses *. On a table page, I can use `modifyQueryUSelect field using search populate another field.I have a select field that populates the options via an external API request: ``` Forms\Components\Continuation of this conversationhttps://discord.com/channels/883083792112300104/956270111176679516/1245383291591200829Position row action before columnsFilament has in the docs a way to position all actions before columns but what if i only want to posSearchable and reactive select fields not functioningSo essentially what I'm trying to achieve is having a form where everything is disabled except the fValidate multiple dynamic fieldshey there. I need to validate muliple dynamic fields in a special way. if you look at the screenshotReordering a table with a 0-based indexHeya everyone! We're on Filament v3 and we're using the `->reorderable()` method on a Resource TableThe "3.2" constraint for "filament/filament"I'm trying to instal filament on a fresh laravel 11 seup but I get this error message all the time.