Doesn't work with the following pipeline and dataset

[javaknight]

In Meteor:

        var pipeline = [
            {$match: { "shipperZip.start" : {$lte: '07621'},
                       "shipperZip.end"   : {$gte: '07621'}}},
            {$unwind : "$recipientZip"},
            {$match: {"recipientZip.start": {$lte: '90011'},
                      "recipientZip.end":   {$gte: '90011'}}},
            {$project: {"recipientZip.expressZone": 1,
                        "recipientZip.groundZone": 1}}
        ];
        var results = myCollection.aggregate(pipeline);
        console.log(results);

yields
empty square brackets []
no data

In Mongo

db.sampleData.aggregate([{$match: {"shipperZip.start":{$lte: "07621"}, "shipperZip.end": {$gte: "07621"}}}, {$unwind: "$recipientZip"}, {$match: {"recipientZip.start": {$lte: "90011"}, "recipientZip.end": {$gte: "90011"}}}, {$project: {"recipientZip.expressZone": 1, "recipientZip.groundZone": 1}}])

yields:

{
"result" : [
{
"_id" : ObjectId("559ea710df8141168fb60ecd"),
"recipientZip" : {
"expressZone" : "8",
"groundZone" : "8"
}
}
],
"ok" : 1
}

Sample Collection (1 document):

{ 
    "_id" : ObjectId("559ea710df8141168fb60ecd"), 
    "shipperZip" : {
        "start" : "07000", 
        "end" : "07699", 
    }, 
    "recipientZip" : [ 
        {
            "start" : "90000", 
            "end" : "91000", 
            "expressZone" : "8", 
            "groundZone" : "8"
        },
    ]
}

[kluch]

I have encountered the same issue.

It looks like according to my tests that it only runs the first match and then ignores the following match and group in this query:

var insertResultsAgg = WorkRequestItemCollection.aggregate(
  {$match : {wriType: {$in:["Type1", "Type2"]}}},
  {$unwind : "$wf"},
 {$match : {$or: [{"$wf.wfAssignedTo":{$in:["Jimmy"]}},{"$wf.wfFromUser":{$in:["Jimmy"]}}]}},
  {$group : {_id:"$_id"}}
);

[jedwards1211]

Use https://github.com/JcBernack/meteor-reactive-aggregate

[ovidb]

@kluch in your case I think it should work if you wrap your pipeline in square brackets.

[SevenZark]

@ovidb Thanks for that! I was having the same problem and missed that small detail also (my pipeline was not actually wrapped in an array, but a series of comma-separated object literals -- I just forgot to wrap them in an array). This is a very easy mistake to make, since it will "fail" silently, since the comma-separated objects after the first one are just extra arguments to the function that will get ignored.