mongodb java driver aggregate group by

Question

I am trying to write group by aggregate function using mongodb java driver.

Here's the document structure of database.

{ "_id" : ObjectId("58819bd9f16a7802523bc077"), "Date" : "12/19/2016", "Time" : "4:15:00", "Temperature" : 65.5, "User" : "A", "ThermalComfort" : -1, "settingID" : ObjectId("58819bd6f16a7802523bbdc5") }
{ "_id" : ObjectId("58819bd9f16a7802523bc078"), "Date" : "12/19/2016", "Time" : "4:30:00", "Temperature" : 65.25, "User" : "A", "ThermalComfort" : -1, "settingID" : ObjectId("58819bd6f16a7802523bbdc5") }

I would like to group by "Date" and "Time", projecting ThermalComfort only. My expected output is this: {date=12/19/16, time=0:00:00, listOfTC = [2,1]}. listOfTC is a list made of each readings in Array: (e.g. [-1,-1])

Here's the code that I wrote.

AggregateIterable<Document> iterable = themalComfortProfileCollection.aggregate(Arrays.asList(
            new Document("$group", new Document("_id", "$Date" + "$Time").append("count", new Document("$sum", 1))),
            new Document("$project", new Document("comfortIndex", "$ThermalComfort"))));

However, if I print out document, I am getting null document.

for (Document doc : iterable) {
    System.out.println(doc);
}

Document{{_id=null}}

Could you explain which part is wrong?

Answer 1

So, finally, this code returned a result what I wanted.

    AggregateIterable<Document> iterable = themalComfortProfileCollection.aggregate(Arrays.asList(
            new Document("$group", new Document("_id", new Document("date", "$Date").append("time", "$Time") ).append("ThermalComfortList", new Document("$push", "$ThermalComfort"))),
            new Document("$sort", new Document("_id", 1))));