laravel - how to sort by count of relation with WHERE

Question

I'm running this query filtering relation entries. It's working good.

$places = Place::
                with([
                  'mytickets' => function($q) use ($from, $to) {
                    $q->whereBetween('used_at', [$from, $to]);
                  }])
                ->get();

So now I want to get results sorting DESC by the count of mytickets.

Is it possible?

Atika · Accepted Answer · 2021-10-08 11:53:17Z

1

Yes, it's possible. Try something like : (i haven't tested)

$places = Place::with(['mytickets' => function($q) use ($from, $to) {
                 $q->whereBetween('used_at', [$from, $to]);
               }
          ])
          ->get()
          ->sortBy(function($places){
               return $places->mytickets->count();
          });

answered Oct 8, 2021 at 11:53

Atika

1,0672 gold badges8 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

anderlaini Over a year ago

it worked but it gets ASC. is there any way to make it DESC?

Atika Over a year ago

yes, use sortByDesc

Collectives™ on Stack Overflow

laravel - how to sort by count of relation with WHERE

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related