Java QueryBuilder in MongoDB

[Maulik]

Hi,

I have to implement following logic in my query.

qry.append(" AND ( EXPIRATION_DATE is null OR
trunc(EXPIRATION_DATE) >= :expirationDate) ");
qry.append(" AND ( release_date IS NULL OR
trunc(release_date)<= :publishDate ) ");

How would I perform these operations by using QueryBuilder? Is there
other way around?

[Scott Hernandez]

Can you express/run this query in the mongo javascript shell?

> --
> You received this message because you are subscribed to the Google Groups "mongodb-user" group.
> To post to this group, send email to mongod...@googlegroups.com.
> To unsubscribe from this group, send email to mongodb-user...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/mongodb-user?hl=en.
>
>

[Sam Millman]

Can you give us the full query you are only showing us a fraction of the SQL query you wish to transfer.

Firstly the trunc() function is not needed since using timestamps you can over come the nessecary overhead of having to split dates up and garnish their "parts".

[padmaprasad]

Hi,

 

Could u help me sort out this problem :

mysql

select fieldOne from coll where fieldOne in (2,3);

//WORKING

In mongo shell

db.coll.find({"fieldOne" : { "$in" : [2,3] }})

//NOT WORKING IN JAVA

In Java

(1)

BasicDBObject queryConditions = new BasicDBObject();

DBObject q = QueryBuilder.start("fieldOne").in(2).get();

queryConditions.put("fieldOne", q);

DBCursor cursorConsumers = coll.find(queryConditions);

cursorConsumers.hasNext();

(2)

String[] array = {"2","3"};

BasicDBObject queryConditions = new BasicDBObject();

DBObject q = QueryBuilder.start("fieldOne").in(array).get();

queryConditions.put("fieldOne", q);

DBCursor cursorConsumers = coll.find(queryConditions);

cursorConsumers.hasNext();

(3)

String[] array = {"2","3"};

DBObject q = QueryBuilder.start("fieldOne").in(array).get();

DBCursor cursorConsumers = coll.find(q);

cursorConsumers.hasNext();

I've tried these in java but not working, So any suggestions will be valuable.

Thanks & Regards,

Padmaprasad

[Scott Hernandez]

Please create a new issue and don't respond to an old one.

Strings are not numbers. Do this:

Long[] array = {2,3};

DBObject q = QueryBuilder.start("fieldOne").in(array).get();

//print "q.toString()" to see the query before you run it.
DBCursor cursorConsumers = coll.find(q);
//foreach loop here

> --
> You received this message because you are subscribed to the Google
> Groups "mongodb-user" group.
> To post to this group, send email to mongod...@googlegroups.com

> To unsubscribe from this group, send email to
> mongodb-user...@googlegroups.com

> See also the IRC channel -- freenode.net#mongodb

[padmaprasad]

Hi Scott,

Thanks for the help,it worked.

Thanks and regards,

Padmaprasad 

[padmaprasad]

Hi,

  DBObject query = QueryBuilder.start("fieldA").greaterThan("fieldB").get();

  not working

  I want to query like SELECT * FROM collection WHERE fieldA > fieldB using monogdb in java.

 Thanks 

 Padmaprasad

[Scott Hernandez]

That is not possible with the query language, and has nothing to do
with the java builders. You cannot yet compare two fields like that
without using javascript in a $where clause:
http://www.mongodb.org/display/DOCS/Server-side+Code+Execution#Server-sideCodeExecution-%7B%7B%24where%7D%7DClausesandFunctionsinQueries

There is a feature request for something like this but it not scheduled yet.