Where function query withcount not working Laravel

Question

this works perfectly fine

return Webinar::query()
        ->withCount('users')->orderByDesc('users_count')
        ->get();

but I need to use a condition for sorting, but this doesnt work

return Webinar::query()
        ->where(function($query) use ($sort_by) {
             if($sort_by == 0) {
                  return $query->withCount('users')->orderByDesc('users_count');
             } else {
                  return $query->withCount('review')->orderByDesc('review_count');
             }
        })
        ->get();

I also tried a condition inside like this to check my if else function

return Webinar::query()
        ->where(function($query) use ($sort_by) {
             if($sort_by == 0) {
                  return $query->withCount('users')->orderByDesc('users_count')
                         ->where('status', 2);
             } else {
                  return $query->withCount('review')->orderByDesc('review_count')
                         ->where('status', 1);
             }
        })
        ->get();

but the where status is only working not withcount. I hope someone can answer, thank you so much

atma · Accepted Answer · 2022-01-15 06:26:52Z

1

How about you move condition code outside query

but I need to use a condition for sorting, but this doesnt work

if ($sort_by === 0) {
    $order = 'users_count';
    $count = 'users';
} else {
    $order = 'review_count';
    $count = 'review';
}

return Webinar::query()
->withCount('users')->orderByDesc($order)
->get();

edited Jan 15, 2022 at 6:26

answered Jan 15, 2022 at 4:48

atma

2142 silver badges10 bronze badges

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

Collectives™ on Stack Overflow

Where function query withcount not working Laravel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related