Mongodb java Query Builder

Question

I am new to java. How can I build this mongo query in java. Any help/hint will be appreciated.

db.places.find({loc : { $near :[ -122.934326171875,37.795268017578] , $maxDistance : 50 } ,$or:[{"uid":"at"},{"myList.$id" :ObjectId("4fdeaeeede2d298262bb80") } ] ,"searchTag" : { $regex : "Union", $options: "i"} } );

what you have tried uptil now to implement it. Can you show us ? — Ravi Khakhkhar
– Ravi Khakhkhar, Commented Aug 17, 2012 at 8:17

Parvin Gasimzade · Accepted Answer · 2012-08-17 08:36:49Z

6

By using the QueryBuilder you can create the query you wanted. I have created it as follows.

QueryBuilder query = new QueryBuilder();
query.put("loc").near(-122.934326171875, 37.795268017578, 50);
query.or(
        QueryBuilder.start("uid").is("at").get(),
        QueryBuilder.start("myList.$id").is(new ObjectId("5024f2f577a59dd9736ddc38")).get()
            );
query.put("searchTag").regex(Pattern.compile("Union",Pattern.CASE_INSENSITIVE));

When I print the query into the console it looks like :

{ "loc" : { "$near" : [ -122.934326171875 , 37.795268017578 , 50.0]} , 
  "$or" : [ { "uid" : "at"} , { "myList.$id" : { "$oid" : "5024f2f577a59dd9736ddc38"}}] , 
  "searchTag" : { "$regex" : "Union" , "$options" : "i"}
}

I didn't try it but hope it will work.

answered Aug 17, 2012 at 8:36

Parvin Gasimzade

26.1k8 gold badges58 silver badges83 bronze badges

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

1 Comment

atandon Over a year ago

Thanks for your response. Let me try and get back to you.

Collectives™ on Stack Overflow

Mongodb java Query Builder

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