mongodb aggregate to get length of first nested array/list

Question

I have following example

{ username : 'Alex', tags: ['C#', 'Java', 'C++'] }

To get the length of tags array

db.users.aggregate(
[
  {
     $project: {
        tags_count: {$size: "$tags"}
     }
  }
]
)

But how to get the length when I have nested lists

{ username : 'Alex', tags: [['C#', 'Java', 'C++']] }


res = collection.aggregate([{
    "$match": query
},{
    "$project": {
      "_id": 0,
      "name": "$name",
      "a1":{"$properties.has_a":{"$slice":1}}, //Line #a1
    }
}])

I also tried changing Line #a1 as follows too:

res = collection.aggregate([{
    "$match": query
},{'$group':{'_id':{'a_list':{'$first':"$properties.has_a"}}}},{
    "$project": {
      "_id": 0,
      "name": "$name",
      "a1":{"$size":'$id.a_list'}, //Line #a1
    }
}])

But nothing is working as expected

Document:

{
  u'_id': ObjectId('54ddcd23f084a315hju481ea'),
  u'properties': [
      {u'start_time': datetime.datetime(2015, 2, 13, 0, 0)},
      {u'end_time': datetime.datetime(2015, 2, 13, 0, 0)},
      {u'status': u'APPROVAL'},
      {u'has_a': [
            ObjectId('54ddc9d6f084a517dfebdeff'),
            ObjectId('54ddc9dbf084a397dfebdf1a')
        ]
       }
      {u'has_b': [
            ObjectId('54ddf9d6f084a317dfebdeff'),
            ObjectId('54dhj9dbf084a317dfebdf1a')
        ]
       }
  ]
}

It may also happen that the has_a has empty list like [] .

score 2 · Answer 1 · edited May 23 '17 at 12:20

2

As I said in the comments, an $unwind stage followed with a $project & $size will fix your problem:

[
   {
        $unwind : "$tags"
   },
   {
        $project: {
               tags_count: {$size: "$tags"}
        }
   }
]

gives me this document:

{
    tags_count: 3
}

This answers your new question:

[
    {
         $unwind : "$properties"
    },
    {
         $unwind : "$properties.has_a"
    },
    {
         $group: {
             _id: null,
             count: {
                 $sum: 1
             }
          }
    }
]

returns following:

{ count: 2}

edited May 23 '17 at 12:20

Community

1
1

answered Feb 16 '15 at 10:36

anvarik

6,417
5
39
53

This is not working. My tags is a list of list of objectIds'. This code is returning me an empty list – rkatkam Feb 16 '15 at 12:59
@rkatkam objectIDs should work as well, post one of your documents – anvarik Feb 16 '15 at 13:29
1

@rkatkam where is $unwind? And please post one of your documents – anvarik Feb 16 '15 at 13:47
I posted the document. Please have a look because I din't find any solution yet – rkatkam Feb 17 '15 at 11:13

mongodb aggregate to get length of first nested array/list

1 Answers1

Linked