Laravel Mongodb aggregate match is not working

Question

I'm trying to get users posts with mongodb in laravel, this query is working fine in mongodb shell but it's not working in laravel and it gives me this error :

A pipeline stage specification object must contain exactly one field.

this is my query in mongodb shell :

db.instaPosts.aggregate([ 
 {"$match" :{ "userid" : "1507073550"}}, 

{"$group" : 
{ "_id" : "$post.location.id", 
"location" : {"$first":"$post.location.name"},

"count":{ "$sum" : 1}}} 
])

and this the results :

{ "_id" : null, "location" : null, "count" : 7 }
{ "_id" : "332558707", "location" : "Daryache Chitgar,Tehran,Iran", "count" : 1 }
{ "_id" : "250445386", "location" : "دانشگاه علم و فرهنگ", "count" : 1 }
{ "_id" : "1343757649052341", "location" : "Agor Caffe", "count" : 1 }
{ "_id" : "111106416225578", "location" : "Santiago Bernabeu, Madrid", "count" : 1 }
{ "_id" : "506047058", "location" : "Cardiff City Stadium", "count" : 1 }

and this is my controller :

        $places = Posts::raw(function ($collection){
            return $collection->aggregate([
               [
                   '$match' => [
                           'userid' => [ '$eq' => '1507073550']
                   ],
                    '$group'=> [
                        '_id' => '$post.location.id',
                        'location' => [
                            '$first'=>'$post.location.name'
                        ],
                        'total' => [
                            '$sum' => 1
                        ],
                    ]
               ]
            ]);
        });

exact same things! but it's not working.

Mehdi Alikhani · Accepted Answer · 2020-07-13 13:56:21Z

1

Finally found the solution!

        $places = Posts::raw(function ($collection){
            return $collection->aggregate([
               [
                   [
                   '$match' => [
                           'userid' => [ '$eq' => '1507073550']
                      ],
                   ],
                   [
                    '$group'=> [
                        '_id' => '$post.location.id',
                        'location' => [
                            '$first'=>'$post.location.name'
                        ],
                        'total' => [
                            '$sum' => 1
                        ],
                      ]
                   ]
               ]
            ]);
        });

I should've wrap $match and $group with [] ,

answered Jul 13, 2020 at 13:56

Mehdi Alikhani

1411 gold badge5 silver badges15 bronze badges

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

1 Comment

George Over a year ago

one external [] should be removed. '$match' should be before '$group' it's important !!!

Collectives™ on Stack Overflow

Laravel Mongodb aggregate match is not working

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related