Filament•2y ago

show data based on data in database

i want to show data based on data in database example: [ 0 => public 1 => private ]

9 Replies

Vp•2y ago

Can you be more specific, in table or select? or where do you want to check this condition?

shissaaaOP•2y ago

if have email verified at then just show verified else show not verified

Vp•2y ago

In the resource you can check like below

public static function getEloquentQuery(): Builder
{
    return parent::getEloquentQuery()
        ->whereNotNull('email_verified_at');
}

public static function getEloquentQuery(): Builder
{
    return parent::getEloquentQuery()
        ->whereNotNull('email_verified_at');
}

Or you can provide filter which will show "email_verified" only, and provide options to show all

Dennis Koch•2y ago

Have a look at Filters in the docs.

shissaaaOP•2y ago

I mean it will show all data. but it will show based on data in database when null, will show not verified. when have datetime, will show verified can you help me

Dennis Koch•2y ago

You can use a BooleanColumn and getStateUsing()

shissaaaOP•2y ago

oh, thank you so much

Noxo•2y ago

TextColumn::make('email_verified_at')
    ->getStateUsing(fn ($record) => is_null($record->email_verified_at) ? 'Not verified' : 'Verified')
    ->badge(),

TextColumn::make('email_verified_at')
    ->getStateUsing(fn ($record) => is_null($record->email_verified_at) ? 'Not verified' : 'Verified')
    ->badge(),

shissaaaOP•2y ago

thank you so much

Gaming

Programming

show data based on data in database

Did you find this page helpful?