MongoDB Java Driver: Aggregation using $match with multiple condition

Question

I've been doing some search but haven't been able to find the answer. From docs, In mongo, if

$match: { type: "airfare"}

translated as:

DBObject match = new BasicDBObject("$match", new BasicDBObject("type", "airfare") );

in Mongo Java driver, how to translate this one into Mongo java driver?

$match : { score : { $gt : 70, $lte : 90 } }

EDIT

This is what I actually wanted to do:

$match : { bookingDateTime: { $gte : fromDate, $lte : toDate } }

And this is how implemented in mongodb java driver, with no luck so far:

DBObject matchFields2 = new BasicDBObject("$match", new BasicDBObject("bookingDateTime", new BasicDBObject("$gte", fromDate.getTime()).append("$lte", toDate.getTime())));
DBObject match2 = new BasicDBObject("$match", matchFields2);

fromDate is a Calendar object so hence the getTime() method to convert Calendar class to Date class.

Tony · Accepted Answer · 2013-07-11 10:13:27Z

3

Object match = new BasicDBObject("$match", 
   new BasicDBObject("score",
   new BasicDBObject("$gt", 70).append("$lte", 90) ) )

edited Jul 11, 2013 at 10:13

Tony

10.4k3 gold badges51 silver badges78 bronze badges

answered Jul 11, 2013 at 9:52

Abhishek Kumar

3,3662 gold badges20 silver badges32 bronze badges

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

5 Comments

fatarms Over a year ago

Thanks. Anyway, i tried to do this for querying match by date:

fatarms Over a year ago

But it did not work and always return empty values. The code can be seen on the edited section.

Abhishek Kumar Over a year ago

can you cross check that if there are documents matching this query, run the command in your mongo shell. db.coll.find({ bookingDateTime : {$gte : fromData, $lte : toDate} })

fatarms Over a year ago

yes, it found some documents using the following query: db.BookingJob.find({ bookingDateTime : {$gte : start, $lte : end} }); where var start = new Date(2013, 6, 12, -16, 00, 00); and var end = new Date(2013,6, 12,7, 59, 59);

Abhishek Kumar Over a year ago

DBObject matchFields2 = new BasicDBObject("$match", new BasicDBObject("bookingDateTime", new BasicDBObject("$gte", fromDate.getTime()).append("$lte", toDate.getTime()))); DBObject match2 = new BasicDBObject("$match", matchFields2);

you don't have to use match2, use the first variable itself i.e. db.getCollection('coll').aggregate(matchFields2)

Collectives™ on Stack Overflow

MongoDB Java Driver: Aggregation using $match with multiple condition

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related