Remove an entry from array using MongoDB-Java driver

Question

I have JSON like :

{ 
    "_id" : "1",
    "_class" : "com.model.Test",
    "itemList" : [
        {
            "itemID" : "1",
            "itemName" : "Foo",
            "resources" : [ 
                { 
                    "resourceID" : "1",
                    "resourceName" : "Foo Test1"
                 }, {
                    "resourceID" : "2",
                    "resourceName" : "Foo Test2"
                 }
             ]
        }
    ]
}

I need to be able to remove one of records of itemList. I have done the following:

public void removeItemByID(String docID, String itemID) throws Exception {
    MongoOperations mongoOperations = mongoConfiguration.getMongoTemplate();
    Query query = new   Query(where("_id").is(docID).and("itemList.itemID").is(itemID));
    mongoOperations.remove(query, Item.class);

}

This approach doesn't work. However when I have used the BasicDBObject with $pull approach it works fine ! What's the difference among these approaches !

Using Bson is similar. I put an answer here

HenioJR
– HenioJR

2016-06-15 21:39:12 +00:00
Commented Jun 15, 2016 at 21:39 — HenioJR
– HenioJR, Commented Jun 15, 2016 at 21:39

Jack · Accepted Answer · 2016-08-29 16:17:39Z

12

If you want to remove an array generally I use the following:

BasicDBObject match = new BasicDBObject("_id", "1"); // to match your document
BasicDBObject update = new BasicDBObject("itemList", new BasicDBObject("itemID", "1"));
coll.update(match, new BasicDBObject("$pull", update));

edited Aug 29, 2016 at 16:17

Jack

1558 bronze badges

answered Apr 11, 2012 at 5:36

dash1e

7,8251 gold badge32 silver badges39 bronze badges

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

1 Comment

Echo Over a year ago

Yes that what I use but I was wondering if I can use Query with MongoOperations to achieve that.

bsmk · Accepted Answer · 2014-03-22 13:17:47Z

5

The remove method from template removes document. If you want to remove item from array you have to use pull. Something like

MongoOperations mongoOperations = mongoConfiguration.getMongoTemplate();
Query query = new Query(where("_id").is(docID).and("itemList.itemID").is(itemID));
Update update = new Update().pull("itemList", new BasicDBObject("itemID", "1"));
mongoOperations.updateFirst(query, update, Item.class);

answered Mar 22, 2014 at 13:17

bsmk

1,3671 gold badge14 silver badges29 bronze badges

Collectives™ on Stack Overflow

Remove an entry from array using MongoDB-Java driver

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related