MongoDB Java driver - date query

Question

I am new to MongoDB and Java and I am trying to retrieve data from MongoDB using a date field.

Data:

{
    "_id" : {
        "timeSlice" : [ 
            2018, 
            5, 
            1
        ],
        "type" : "TRANSMISSION",
        "@objectName" : "SettlementInstance"
    },
    "Versions" : [ 
        {
            "id" : "dc57888a-c070-465f-9f2d-cbc5f2b69a09",
            "status" : "ACTIVE",
            "version" : NumberLong(10007)
        }
    ]
}

MongoDB query I use:

db.getCollection('SettlementInstance').find({"_id.timeSlice" : [2018,5,1]})

How to use this date field in Java with SQUARE Brackets and Integer dates together?

Any suggestion will be really helpful.

your query looks OK to me. Try this `db.SettlementInstance.find( { "_id.timeSlice": { $all: [ 2018,5, 1 ] } } )` — Muhammad Usman, Apr 10 '18 at 06:06

score 0 · Accepted Answer · answered Apr 10 '18 at 08:07

The following code will find the document you supplied in your question:

// 3.x driver idiom
Bson filter = Filters.eq("_id.timeSlice", Arrays.asList(2018, 5, 1));

// 2.x driver idiom
// Bson filter = new BasicDBObject("_id.timeSlice", Arrays.asList(2018, 5, 1));

collection.find(filter);

MongoDB Java driver - date query

1 Answers1