Mongodb group and project operators

Question

I'm trying to group by "group_name" and select fields "group_name" and "group_id" with php driver using aggregation framework:

Array
(
    [$project] => Array
        (
            [group_name] => 1
            [group_id] => 1
        )

    [$group] => Array
        (
            [_id] => $group_name
            [total_sum] => Array
                (
                    [$sum] => 1
                )

        )

)

I'm getting this: [errmsg] => exception: A pipeline stage specification object must contain exactly one field. However, when I'm using only $project or $group operator it works just fine.

Comma separate? http://php.net/manual/en/mongocollection.aggregate.php — Ricky Hartmann, Apr 02 '13 at 02:54
I'm using comma in the code. This is just output of it. Is my structure correct? — Sergey Tsibel, Apr 02 '13 at 03:31

score 4 · Accepted Answer · edited Sep 24 '15 at 17:45

4

The issue is your grouping your $project and $group together.

Your array should look more like

{
  $project: {
    group_name: 1,
    group_id: 1
  },
},
{   
  $group:{
    _id:{
      group_name:'$group_name',
    },
    total_sum:{$sum:1}
  }
}

edited Sep 24 '15 at 17:45

Adriano P

2,045
1
22
32

answered Apr 25 '13 at 10:04

RedPhoenix

306
2
3

score 0 · Answer 2 · answered Apr 02 '13 at 03:01

0

You'll need to reformat and also use commas as separators. It's a pipeline so it takes each item in at a time.

I haven't tried this but try:

array
(
array(
array(
    '$project' => array(
        "group_name" => 1,
        "group_id"   => 1,
    )
),

array(
    '$group' => array(
        "_id" => array("group_name" => '$group_name'),
        "total_sum" => array('$sum' => 1),
    ),
)
)

answered Apr 02 '13 at 03:01

Ricky Hartmann

891
1
7
20

I'm using commas in the code. This is just output for simplicity. Why did you put one extra array over another one? And no, didn't work – Sergey Tsibel Apr 02 '13 at 03:25

Mongodb group and project operators

2 Answers2

Linked