How to get array of document using Mongodb java?

Question

How to get all the document under array in mongodb java. My Database is as below. Want to retrieve all the data under array 198_168_1_134.

enter image description here

below is some of What i tried,

eventlist.find(new BasicDBObject("$match","192_168_10_17"))
eventlist.find(new BasicDBObject("$elemMatch","192_168_10_17"))
eventlist.find(null, new BasicDBObject("$192_168_10_17", 1))

How can we copy and paste code from an image so that we can help you by reproducing the same problem on our PCs? — chridam
– chridam, Commented Apr 21, 2015 at 11:52
@chirdam it's just for reference that how database is look a like. — Hitesh Vaghani
– Hitesh Vaghani, Commented Apr 21, 2015 at 11:56

Konstantin Yovkov · Accepted Answer · 2015-04-21 12:21:41Z

1

You have two options:

using .find() with cherry-picking which document you have to have fetched.
using the aggregation framework by projecting the documents.

By using .find() , you can do:

db.collection.find({}, { 192_168_10_17 : 1 })

By using the aggregation framework, you can do:

db.collection.aggregate( { $project : { 192_168_10_17 : 1 } } )

which will fetch only the 192_168_10_17 document data.

Of course, in order to get this working in Java, you have to translate these queries to a corresponding chain of BasicDBObject instances.

edited Apr 21, 2015 at 12:21

answered Apr 21, 2015 at 11:59

Konstantin Yovkov

63k9 gold badges107 silver badges152 bronze badges

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

1 Comment

Konstantin Yovkov Over a year ago

Should be working. Try it out again. Anyway, I'm glad I helped you. :)\

Vishwas · Accepted Answer · 2015-04-23 16:14:13Z

0

By using mongo java driver you can do this by following query -

eventlist.find(new BasicDBObject(), new BasicDBObject("198_168_1_134", 1))

edited Apr 23, 2015 at 16:14

answered Apr 21, 2015 at 12:01

Vishwas

7,0777 gold badges46 silver badges70 bronze badges

Collectives™ on Stack Overflow

How to get array of document using Mongodb java?

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