MongoDB Array modify Using Java

Question

I am new to MongoDB, I want to remove an element from array structure as shown below:

{
    "Data" : [
        {           
            "url" : "www.adf.com"
            "type":7
        },
        {

            "url" : "www.pqr.com"
            "type":2
        }
        {           
            "url" : "www.adf.com"
            "type":3
        },
        {

            "url" : "www.pqr.com"
            "type":5
        }
    ],

}

I want to remove url=www.adf.com which has type as lowest values i.e in this document my query should remove type=3 and return document as below:

{
        "Data" : [
            {           
                "url" : "www.adf.com"
                "type":7
            },
            {

                "url" : "www.pqr.com"
                "type":2
            }

            {

                "url" : "www.pqr.com"
                "type":5
            }
        ],

    }

Jhanvi · Accepted Answer · 2013-10-28 12:55:34Z

1

The query shown by @shakthydoss can be described in java as follows:

    MongoClient mongoClient = new MongoClient("SERVER", 27017);
    DB db = mongoClient.getDB("DB_NAME");
    DBCollection coll1 = db.getCollection("COLLECTION_NAME");
    DBObject eleMatch = new BasicDBObject();
    eleMatch.put("url", "www.pqr.com");
    eleMatch.put("type", new BasicDBObject("$lte", 50));
    BasicDBObject up = new BasicDBObject();
    up.put("$elemMatch", eleMatch);
    BasicDBList basicDBList = new BasicDBList();
    basicDBList.add(up);
    DBObject query = new BasicDBObject("Data", new BasicDBObject(" $all", basicDBList));
    coll1.find(query);

answered Oct 28, 2013 at 12:55

Jhanvi

5,1599 gold badges34 silver badges41 bronze badges

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

Comments

shakthydoss · Accepted Answer · 2013-10-27 06:59:57Z

0

Use $all with $elemMatch

If the field contains an array of documents, you can use the $all with the $elemMatch operator.

db.inventory.find( {
                 Data: { $all: [
                                { "$elemMatch" : { url : "www.pqr.com": "M", type: { $lte: 50} } },

                              ] }
               } )

answered Oct 27, 2013 at 6:59

shakthydoss

2,6416 gold badges29 silver badges37 bronze badges

3 Comments

GaneshP Over a year ago

i need in java not in mongo shell

shakthydoss Over a year ago

If you dont know the value ($lte: 50) to be compared then use map reduce approach to find the array element.

shakthydoss Over a year ago

Can past what your java snippet that you have tried so far. Let me see if I can help you.

Collectives™ on Stack Overflow

MongoDB Array modify Using Java

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related