Select specific fields in a nested map object schema in Mongo DB

Question

Eg:- Following is a sample document in a collection 'clubs',

Sample document

{
    "_id" : ObjectId("5cb8218ce2911e7c707e27fa"),
    "name" : "name 1",
    "members" : {
        "user_1" : {
            "created" : ISODate("2019-04-18T07:04:44.748Z"),
            "lastActive" : 1555584757282,
            "state" : 1,
            "unreadMessages" : 0,
            "userId" : "user_1_id"
        },
        "user_2" : {
            "lastActive" : 1555588409686,
            "state" : 1,
            "unreadMessages" : 0,
            "userId" : "user_2_id"
        }
    }
}

Mongo DB query should return the following fields :-

Desired Output-

{
    {
        "_id" : ObjectId("5cb8218ce2911e7c707e27fa"),
        "name" : "name 1",
        "members" : {
            "user_1" : {
                "lastActive" : 1555584757282
            },
            "user_2" : {
                "lastActive" : 1555588409686
            }
         }
    }
}

Ashh · Accepted Answer · 2019-05-01 05:29:11Z

1

You can use below aggregation

db.collection.aggregate([
  { "$addFields": {
    "members": {
      "$arrayToObject": {
        "$map": {
          "input": { "$objectToArray": "$members" },
          "in": {
            "k": "$$this.k",
            "v": { "lastActive": "$$this.v.lastActive" }
          }
        }
      }
    }
  }}
])

Example

edited May 1, 2019 at 5:29

answered Apr 18, 2019 at 14:16

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

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

1 Comment

Ashima Walia Over a year ago

The username in members object can be different in each document. I need to write a query to find the lastActive timestamp in all the documents for all the different users.

Collectives™ on Stack Overflow

Select specific fields in a nested map object schema in Mongo DB

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