Mongodb java Query Builder

java mongodb query-builder mongo-java
atandon picture atandon · Aug 17, 2012 · Viewed 8k times · Source

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"} } );

Answer

Parvin Gasimzade picture Parvin Gasimzade · Aug 17, 2012

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.

Related questions

Creating a mongodb query in Java with $or and $in

I am trying to write a java code using mongodb api to create this mongodb query: { "$or": [{"prd" : {"$in" : ["1234", "0987"]}} , {"rsin" : "3228742"}]} Here's the code I am working with so far: QueryBuilder builder = new QueryBuilder(); if (builder == null) { builder = QueryBuilder.start(); } if (…

Read More
'Field required a bean of type that could not be found.' error spring restful API using mongodb

So I've been learning Spring in the couples of week, been following this tutorial Building a RESTful Web Service All was well until I tried to integrate it to mongodb. So I follow this tutorial. Accessing Data with MongoDB But …

Read More
TransactionRequiredException Executing an update/delete query

Hi I am using hibernate JPA with spring and mongodb and i am running my application on Glassfish-4.0. My service class is : @Component public class Test { @PersistenceContext EntityManager em; EntityManagerFactory emf; @Transactional public String persist(Details details) { details.getUsername(); details.…

Read More