Boolean fields show inconsistent or blank values in old_values / new_values when toggling between 0 and 1

[tfranssen]

I’m using Laravel Auditing with a TINYINT(1) (non-null) column for a boolean field (e.g. hasTubes). In my Eloquent model, I’ve cast this column to a boolean ('hasTubes' => 'boolean'). When I toggle the field in my Filament form between true (1) and false (0), the audit entries sometimes display the old/new values as 1 or 0, but other times they appear blank (see the screenshot below).

Screenshot

Steps to Reproduce:

1. Use Laravel Auditing on a model with a TINYINT(1) column for a boolean field (e.g. hasTubes), not nullable, default 0.
2. Cast it to 'boolean' in the model’s $casts array.
3. In a Filament form, toggle the field from false to true (or vice versa).
4. View the audit log – notice that old_values or new_values sometimes show 1 / 0 and sometimes display a blank value.

Expected Behavior:

• The old_values and new_values should always show 0 or 1 (or true/false) consistently in the audit log, rather than occasionally appearing blank.

Actual Behavior:

• Occasionally, the audit log for boolean fields appears blank for one of the values, even though the DB is storing 0 or 1 and the model has a correct boolean cast.

Additional Context:

• Model casting array:

  protected $casts = [
      'hasTubes' => 'boolean',
      // ...
  ];

[tfranssen]

---

✅ Solution

I managed to fix this issue in a clean and consistent way, both in how the audit is stored in the database and how it is presented in Filament.

---

1. Normalize booleans when storing audit (transformAudit)

In your model (in my case, Counter), add the transformAudit() method to ensure all boolean fields are stored as true/false instead of 1/0:

use OwenIt\Auditing\Models\Audit;

public function transformAudit(array $data): array
{
    $booleanAttributes = array_keys(array_filter($this->casts, fn ($cast) => $cast === 'boolean'));

    foreach ($booleanAttributes as $attribute) {
        if (isset($data['old_values'][$attribute])) {
            $data['old_values'][$attribute] = (bool) $data['old_values'][$attribute];
        }
        if (isset($data['new_values'][$attribute])) {
            $data['new_values'][$attribute] = (bool) $data['new_values'][$attribute];
        }
    }

    return $data;
}

---

2. Format booleans in Filament audit view

You can also format how the booleans are displayed in the audit log by adding formatAuditFieldsForPresentation() to your model:

use OwenIt\Auditing\Models\Audit;
use Illuminate\Support\Arr;
use Illuminate\Support\HtmlString;

public function formatAuditFieldsForPresentation($field, Audit $record): HtmlString
{
    $fields = Arr::wrap($record->{$field});

    $formattedResult = '<ul>';

    foreach ($fields as $key => $value) {
        if (array_key_exists($key, $this->casts) && $this->casts[$key] === 'boolean') {
            $value = $value ? 'true' : 'false';
        }

        $formattedResult .= "<li><strong>{$key}</strong>: {$value}</li>";
    }

    $formattedResult .= '</ul>';

    return new HtmlString($formattedResult);
}

---