time search on date not working

[Rasoul-Karimi]

hi
i want to get all item From '2023-01-31 07:00:00' until '2023-01-31 07:30:00' for example:

i search looks like: search=start_at:'2023-01-31 07:00:00', '2023-01-31 07:30:00'&searchFields=start_at:between and in config file add between condition but not working! search on hour and minute not work! return all days!

[Rasoul-Karimi]

??

[jeffersonsalvador]

I had a similar problem, when I search for some time for example: 14:00.
Apparently it's breaking all information containing ":" into field:value

?search=schedule.expression:'14:00'

?search="14:00"

[Rasoul-Karimi]

up

[Rasoul-Karimi]

any answer and solution?

[mCassy]

I do not think there is a quick/simple solution to this since attr/value separators are hardcoded in the RequestCriteria class.

Personally, I would go with some custom criteria class that I would push whenever it's needed. For example, having
?start_at='2024-01-01 12:14:25,2025-01-01 12:14:25' query param you can create a custom criteria class that accepts your start_at value

class StartAtBetweenCriteria implements CriteriaInterface
{
    public function __construct(private string $startAtBetween)
    {
    }

    public function apply($model, RepositoryInterface $repository)
    {
        $startAtBetween = explode(',', $this->startAtBetween);
        if (isset($startAtBetween[0]) && isset($startAtBetween[1])) {
            $model = $model->whereBetween("start_at", "=", $startAtBetween);
        }
        return $model;
    }
}

Later on, you can push this criteria whenever you need it, ie

$this->repository->pushCriteria(new StartAtBetweenCriteria($request->get('start_at')));