Mongodb remove item from array

Question

I'm trying to remove an element from an array using Java and haven't been successful...

I have a "emailsInApp" collection and inside I have this:

{ "_id" : "750afe", "list" : [ "[email protected]", "[email protected]" ] }
{ "_id" : "711850", "list" : [ "[email protected]" ] }

It holds for each id the registered emails.

What I would like to do is: given an id and an email, remove that email from that appId.

This is what I have atm and when I run it it doesn't change the array at all:

DBCollection emailsApp = db.getCollection(EmailsInAppColl);
BasicDBObject queryEmail = new BasicDBObject();
queryEmail.put("_id", appId);
BasicDBObject updateEmailCommand = new BasicDBObject();
updateEmailCommand.put("$pull", new BasicDBObject("list", email));
emailsApp.update(queryEmail, updateEmailCommand, true, true);

Could you point me in the right direction please?

Edit: As reccomended by @Constantine if I debug it this is what I get:

DBCollection emailsApp = db.getCollection(EmailsInAppColl);
queryEmail.put("_id", appId);
DBCursor cursor = emailsApp.find(queryEmail);
System.out.println("######*****"+cursor.next());

In the console:

#####*****{ "_id" : "711850" , "list" : [ "[email protected]" , "[email protected]" , "[email protected]" , "[email protected]"]}

The search query is correct but it does not remove the item...

Make sure you have the right collection name in the DBCollection parameter and check if the appId really exists. Please, debug it this way and tell if it is all correct. — user
– user, Commented Jun 12, 2013 at 9:21
Hi @Constantine, Thank you for the reply. I did test it using a cursor and it found the id. So it is finding the app, the issue is removing the item... — HeWhoBuilds
– HeWhoBuilds, Commented Jun 12, 2013 at 10:31

BenMorel · Accepted Answer · 2014-01-21 09:56:11Z

7

Try something, like this:

BasicDBObject match = new BasicDBObject("_id", appId); //to match your direct app document
BasicDBObject update = new BasicDBObject("list", email);
coll.update(match, new BasicDBObject("$pull", update));

It should work.

edited Jan 21, 2014 at 9:56

BenMorel

37k52 gold badges208 silver badges339 bronze badges

answered Jun 12, 2013 at 12:32

user

3,09825 silver badges46 bronze badges

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

1 Comment

HeWhoBuilds Over a year ago

Thank you very much for the help @Constantine. It happens I was thinking in the wrong way, I changed my array to have an id related to each email. From there it is easier for me to maintain the array and solved the issue. You help me find the right way :)

Collectives™ on Stack Overflow

Mongodb remove item from array

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related