CODEWITHSUNDEEP
laravelfull-text-searchlaravel-scoutmeilisearch
php fox
php fox

Reputation: 3

laravel scout and meilisearch filter and sort desc between two created_at filed date

i want to filter some data between two date in created_at column and sort all by created_at

i don't have timestamp

My Code

$startDate = Carbon::parse('2022-02-01')->startOfDay();
$endDate =  Carbon::parse('2022-02-15')->endOfDay();

    $messages = MessagesArch::search($myQuery)->query(function($q)  use ($startDate,$endDate) {
        return $q->whereBetween("created_at", [$startDate,$endDate]);
    })->orderBy('id','desc')->get();

how i can do this?

Upvotes: 0

Views: 519

Answers (1)

Amit Vishwakarma
Amit Vishwakarma

Reputation: 1

You can try this way:

$startDate = Carbon::parse('2022-02-01')->startOfDay();
$endDate =  Carbon::parse('2022-02-15')->endOfDay();

$messages = MessagesArch::whereBetween("created_at", [$startDate,$endDate])->orderBy('id','desc')->get();

Upvotes: -1

Related Questions