Breaking News: Grepper is joining You.com. Read the official announcement!

group by count mongodb laravel

company MO answered on June 13, 2022 Popularity 5/10 Helpfulness 3/10

answer group by count mongodb laravel

group by count mongodb laravel

Comment

<?php 

$category_ids = []; //categories goes here

$results = Post::raw(function($collection) use ($category_ids) {
    return $collection->aggregate([
        //where in...
        [
            '$match' => [
                'category_id' => ['$in' => $category_ids]
            ]       
        ],  
        [   
            '$group' => [
                '_id' => '$user_id',
                'count' => ['$sum' => 1]   
            ]   
        ],  
        [   
            '$sort' => ['count' => -1]   
        ],  
        [   
            '$limit' => 10
        ],  
    ]); 
});

Popularity 5/10 Helpfulness 3/10 Language php

Source: stackoverflow.com

Tags: count group-by laravel mongodb php

Link to this answer
Share Copy Link