Table with column filter on created_at

[fonpacific]

Hi @tabuna,
I'm trying to add a filter in a table for the column created_at.
This is what I tried so far, following docs, but without any success.

Column created_at is the Laravel's standard created in migration with:

    $table->timestamps();

This is the relevant parts of the Order model:

namespace App\Models;

class Order extends Model
{
    use Filterable;

    protected $allowedFilters = [
        'created_at',
    ];

    /**
     * Prepare a date for array / JSON serialization.
     *
     * @param  \DateTimeInterface  $date
     * @return string
     */
    protected function serializeDate(DateTimeInterface $date)
    {
        return $date->format('d-m-Y');
    }
}

This is the app/Orchid/Screens/OrderListScreen.php file:

<?php

namespace App\Orchid\Screens;

use App\Models\Order;
use App\Orchid\Filters\DateFilter;
use App\Orchid\Layouts\OrderListLayout;
use Orchid\Screen\Screen;

class OrderListScreen extends Screen
{
    /**
     * Query data.
     *
     * @return array
     */
    public function query(): iterable
    {
        return [
            'orders' => Order::filtersApply([DateFilter::class])
                ->filters()
                ->defaultSort('created_at', 'desc')
                ->paginate(100),
        ];
    }

    /**
     * Display header name.
     *
     * @return string|null
     */
    public function name(): ?string
    {
        return 'Orders list';
    }

    /**
     * Button commands.
     *
     * @return \Orchid\Screen\Action[]
     */
    public function commandBar(): iterable
    {
        return [];
    }

    /**
     * Views.
     *
     * @return \Orchid\Screen\Layout[]|string[]
     */
    public function layout(): iterable
    {
        return [
            OrderListLayout::class
        ];
    }
}

Here's app/Orchid/Filters/DateFilter.php:

<?php

namespace App\Orchid\Filters;

use Illuminate\Database\Eloquent\Builder;
use Orchid\Filters\Filter;
use Orchid\Screen\Field;
use Orchid\Screen\Fields\DateTimer;

class DateFilter extends Filter
{
    /**
     * The displayable name of the filter.
     *
     * @return string
     */
    public function name(): string
    {
        return 'Date';
    }

    /**
     * The array of matched parameters.
     *
     * @return array|null
     */
    public function parameters(): ?array
    {
        return [
            'created_at'
        ];
    }

    /**
     * Apply to a given Eloquent query builder.
     *
     * @param Builder $builder
     *
     * @return Builder
     */
    public function run(Builder $builder): Builder
    {
        return $builder->where('created_at', $this->request->get('created_at'));
    }

    /**
     * Get the display fields.
     *
     * @return Field[]
     */
    public function display(): iterable
    {
        return [
            DateTimer::make('created_at')
                ->inline()
                ->format('d-m-Y'),
        ];
    }
}

I'm trying to use the filter in OrderListLayout which extends Table like this:

    TD::make('created_at', 'Delivered')
        ->filter(DateTimer::make('created_at')->inline()->format('d-m-Y'))
        ->sort(),

This is what I get by calling the model with ?filter[created_at]=17-06-2022 as parameter (i.e. choosing a date in datepicker and clickng Apply):

As you can see from the last row visible, filter is not working. If you look at the debugger, there's no query on created_at column (except for sorting use).

Could you please provide some help on filtering a Date column?
Thank you.

[fonpacific]

I'm sorry to bother further, can someone please provide some help?

[fonpacific]

I've been able to have a filter for a date column using

        TD::make('created_at', 'Delivered')
                ->filter(TD::FILTER_DATE_RANGE)

in app/Orchid/Layouts/OrderListLayout.php.
Still I don't get why a filter with single date doesn't work. Could it be a bug?

[Estigy]

Just an idea: Since the created_at column in the database is a DateTime, queries that only provide a date without the time part will almost never yield any answer because "2022-07-23" is not the same as "2022-07-23 11:11:14".
You could try to modify the part in your run() method where the dates are compared. You want only to compare the first part of the column without the specific time.