Deleting nested document from mongo array

Question

this is my mongo doc :

{
    "_id" : ObjectId("51f22f6784aefaa97d7e533e"),
    "group_name" : "demo",
    "privileges" : [
        "User Group",
        "Profile Images",
        "Advertisement"
    ],
    "users" : [
        {
            "full_name" : "aap",
            "password" : "as",
            "status" : "Active",
            "user_name" : "as"
        },
        {
            "full_name" : "b",
            "user_name" : "b",
            "password" : "b",
            "status" : "Active"
        },
        {
            "full_name" : "prashant",
            "user_name" : "pt123",
            "status" : "Active"
        }
    ]
}

I want to find all records having "group_name":"demo" delete particular record having "user_name":"pt123" form users array. I have tried

 db.users.update({"group_name":"demo"}, {$pull:{"users.user_name":"pt123"}})

but showing no effect. Where am i lacking? Please Help My java code is

BasicDBObject del = new BasicDBObject("group_name", z);
del.put("users.user_name", x);
BasicDBObject delquery=new BasicDBObject("$match",del);
con.remove(delquery);

roman · Accepted Answer · 2013-07-27 10:37:46Z

2

Here's working query for you:

db.users.update({"group_name":"demo"}, {$pull: {"users":{"user_name":"pt123"}}})

answered Jul 27, 2013 at 10:37

roman

118k30 gold badges205 silver badges209 bronze badges

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

Comments

Prashant Thorat · Accepted Answer · 2013-07-27 11:26:43Z

1

      BasicDBObject sq = new BasicDBObject("group_name", z);
      BasicDBObject idoc=new BasicDBObject("user_name",x);
      BasicDBObject odoc =new BasicDBObject("users",idoc);
      BasicDBObject delq=new BasicDBObject("$pull",odoc);
      con.coll.update(sq, delq);

answered Jul 27, 2013 at 11:26

Prashant Thorat

1,91211 gold badges35 silver badges59 bronze badges

Collectives™ on Stack Overflow

Deleting nested document from mongo array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related