Add new object to sub of sub array based on query in MongoDB using mongotemplate

Question

Here is an existing document:

{
    "_id": ObjectId("58bfe67c71043e8947d487c7"),
    "_class": "com.plash.configurator.model.GmailMailData",
    "useremail": "[email protected]",
    "threadidslist": [
     {
       "threadid": "15aac9952c924e6c",
       "subject": "dd",
       "messagelist": [
         {
           "messageid": "15aad9c4ebba913c",
           "timestamp": "Wed Mar 08 11:09:45 UTC 2017",
           "from": "[email protected]",
           "body": "<div dir=\"ltr\">ddd</div>\r\n",
           "labelid": "RECEIVED"
         }
       ]
     }
    ]
}

The query I am using is:

Update update = new Update();
update.addToSet("messagelist", gm); //gm is the object of messaglist
Criteria criteria =  Criteria.where("useremail").is(useremailid)
                             .and("threadidslist.threadid").is(threadid);
mongoTemplate.updateFirst(Query.query(criteria), update, GmailMailData.class);

This query inserts the object at the top level, but I want the object to be added inside messagelist.

How do I add a new object inside messagelist if useremail and threadid matches?

Can you try update.addToSet("threadidslist.$.messagelist", gm) ? — s7vr
– s7vr, Commented Mar 9, 2017 at 10:59

utsav anand · Accepted Answer · 2017-03-09 11:48:21Z

1

This query works:

 Query query = new Query(Criteria.where("useremail").is(useremailid).and("threadidslist.threadid").is(threadid));
            update.push("threadidslist.$.messagelist", gm);
            mongoTemplate.updateFirst(query, update, GmailMailData.class);

answered Mar 9, 2017 at 11:48

utsav anand

3851 gold badge4 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

Add new object to sub of sub array based on query in MongoDB using mongotemplate

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related