Aggregation with JAVA

Prem_Parmar · March 11, 2020, 10:43am

Hello,
There is not enough information available on documentation about “GROUP By” in JAVA language.You should provide some better example and brief explanation about all Aggregation operation so that everyone can understand easily.
We can use GROUP by with DBObject also but in GROUPOPERATION method, It is fatigue task to do as it is not easily understandable.
I hope, You may see this request and take immediate action.

Thank you…

steevej · March 11, 2020, 11:38am

One thing that helped me a lot with aggregation is the course M121 - The MongoDB Aggregation Framework from https://university.mongodb.com/

I also use MongoDB Compass | MongoDB to built my pipelines.

Finally, since I have projects in Java, some in nodejs and use the shell on daily basis, I keep my aggregation pipelines in json, even in Java where I do not use the aggregation builder classes.

chris · March 11, 2020, 2:16pm

I second @steevej on both M121 and compass.

Prasad_Saya · March 11, 2020, 3:15pm

You can try the newer (and easy to use) com.mongodb.client.model.Aggregates aggregation pipeline builder class’s group methods. Also see Aggregation Tutorials and Example usage of Aggregates.

As of Java driver v3.9 GroupOperation is deprecated.

Compass’s Aggregation Pipeline Builder has Export Pipeline to Specific Language feature, and this allows the built pipeline to be converted to corresponding Java code.

Prem_Parmar · March 11, 2020, 6:49pm

Aggregation.group("$folder._id").first(“folder.name”).as(“name”).count().as(“count”)
Aggregation.group("$folder.id").first(“folder.name”).as(“name”).count().as(“count”)

In Java, for same DTO above bold query works fine. Can you please give me reason behind this and also how this fields works?

collection’s document is :