DatePicker and unique: Format is ignored.

I have a DatePicker with the following methods:

DatePicker::make("published_at")
    ->unique(callback: function(Unique $rule, $livewire) {
        return $rule
            ->where("featured_type_id", $livewire->ownerRecord->id);
    })
    ->format("Y-m-d")
    ->displayFormat("Y-m-d")
    ->default(now()->format("Y-m-d"))
    ->required()

DatePicker::make("published_at")
    ->unique(callback: function(Unique $rule, $livewire) {
        return $rule
            ->where("featured_type_id", $livewire->ownerRecord->id);
    })
    ->format("Y-m-d")
    ->displayFormat("Y-m-d")
    ->default(now()->format("Y-m-d"))
    ->required()

The

published_at

published_at

field is just a

date

date

SQL column (without time). In the form, I wanna see and save the date in

Y-m-d

Y-m-d

format, which is working.

The problem is, that the unique rule never hits, because the generated query (checked it in telescope) is the following:

select
  count(*) as aggregate
from
  `recipes`
where
  `published_at` = '2023-03-31 11:39:34'
  and `featured_type_id` = '1'

select
  count(*) as aggregate
from
  `recipes`
where
  `published_at` = '2023-03-31 11:39:34'
  and `featured_type_id` = '1'

Filament•3y ago•

9 replies

bernhard

DatePicker and unique: Format is ignored.

I have a DatePicker with the following methods:

DatePicker::make("published_at")
    ->unique(callback: function(Unique $rule, $livewire) {
        return $rule
            ->where("featured_type_id", $livewire->ownerRecord->id);
    })
    ->format("Y-m-d")
    ->displayFormat("Y-m-d")
    ->default(now()->format("Y-m-d"))
    ->required()

DatePicker::make("published_at")
    ->unique(callback: function(Unique $rule, $livewire) {
        return $rule
            ->where("featured_type_id", $livewire->ownerRecord->id);
    })
    ->format("Y-m-d")
    ->displayFormat("Y-m-d")
    ->default(now()->format("Y-m-d"))
    ->required()

The

published_at

published_at

field is just a

date

date

SQL column (without time). In the form, I wanna see and save the date in

Y-m-d

Y-m-d

format, which is working.

The problem is, that the unique rule never hits, because the generated query (checked it in telescope) is the following:

select
  count(*) as aggregate
from
  `recipes`
where
  `published_at` = '2023-03-31 11:39:34'
  and `featured_type_id` = '1'

select
  count(*) as aggregate
from
  `recipes`
where
  `published_at` = '2023-03-31 11:39:34'
  and `featured_type_id` = '1'

DatePicker and unique: Format is ignored.

Similar Threads

DatePicker and unique: Format is ignored.

Similar Threads

Similar Threads

Similar Threads