Filament•3y ago•

11 replies

formatStateUsing() and a nullable boolean column

I have a nullable boolean column in a table like:

$table->boolean('decision')->nullable();

$table->boolean('decision')->nullable();

In my Filament table, I'm trying to display 'Pending' for the null value and 'Accepted' or 'Rejected' correspondingly for

true

true

and

false

false

I do not get any

$state

$state

Model $record

Model $record

for the null values at all.

TextColumn::make('decision')
  ->badge()
  ->formatStateUsing(function (Model $record) {
      dump($record);
  })
  ...

TextColumn::make('decision')
  ->badge()
  ->formatStateUsing(function (Model $record) {
      dump($record);
  })
  ...

will not dump anything at all, but works as expected for the non-null values.
same with

TextColumn::make('decision')
  ->badge()
  ->formatStateUsing(function (string $state) {
    dump($state)
  })
  ...

TextColumn::make('decision')
  ->badge()
  ->formatStateUsing(function (string $state) {
    dump($state)
  })
  ...

Any insight would be appreciated.

Solution

Try

getStateUsing()

getStateUsing()

null

null

values are filteres and there is not

formatStateUsing()

formatStateUsing()

for them