Convert mongoDB shell command to java

Question

I am trying to convert the mongodb shell code below to java. However, i run into some problems doing so. Can anyone help me with this issue?

MongoDB

var friend_ids = db.users.findOne(ObjectId("...")).friend_ids
db.users.find({_id:{$in:friend_ids}})

Java

ObjectId id = new ObjectId("...");                  
BasicDBObject fields = new BasicDBObject("friend_ids", 1).append("_id", false);
DBObject f_ids = coll.findOne(id, fields);
BasicDBObject query = new BasicDBObject("_id",(new BasicDBObject("$in", f_ids)));
DBCursor cursor = coll.find(query);

The java query is as follows.

query={ "_id" : { "$in" : { "friend_ids" : [ { "$oid" : "..."} , { "$oid" : "..."} , { "$oid" : "..."}]}}},

thanks

And what exactly are the problems you are running into?

MarioP
– MarioP

2014-01-31 09:54:23 +00:00
Commented Jan 31, 2014 at 9:54 — MarioP
– MarioP, Commented Jan 31, 2014 at 9:54
I do not get the wanted friendlist within java;).

Ramdiman
– Ramdiman

2014-01-31 09:59:36 +00:00
Commented Jan 31, 2014 at 9:59 — Ramdiman
– Ramdiman, Commented Jan 31, 2014 at 9:59

Mustafa Genç · Accepted Answer · 2014-01-31 09:40:41Z

1

You need extract friend_ids from f_ids.

BasicDBObject query = new BasicDBObject("_id",(new BasicDBObject("$in", f_ids.get("friend_ids"))));

answered Jan 31, 2014 at 9:40

Mustafa Genç

2,58920 silver badges36 bronze badges

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

1 Comment

Ramdiman Over a year ago

Wow thanks,That is really quick!. i will accept as correct as soon as possible (5min)

Collectives™ on Stack Overflow

Convert mongoDB shell command to java

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related