In Spring boot Mongodb find group by count by using Aggregation framework

Question

Hi a am try to do rest api in spring boot with mongodb to find group by count the input data look like. please share any logic, code, example link. guys i am expecting spring boot logic. how mongodb aggregation framework integrating.

{
    "_id" : "PRODUCT_01",
    "productname" : "product1",
    "value" : "codesoft"
},
{
    "_id" : "PRODUCT_01",
    "productname" : "product2",
    "value" : "codesoft"
},

{
    "_id" : "PRODUCT_01",
    "productname" : "product1",
    "value" : "codesoft"
}

expected output { product1 : 2, product2 : 1 } Any help is appreciated.

Amit i have create but it is not proper solution that's why i have not share.. — Big data Hadoop dev.
– Big data Hadoop dev., Commented Aug 27, 2018 at 10:06

gaurav singh · Accepted Answer · 2018-08-29 17:41:21Z

4

try this

 db.testColln.aggregate(
{ 
$group : {_id : "$productname", total : { $sum : 1 }}
}
 );

for Spring Boot

Aggregation agg = newAggregation(
        group("productname").count().as("total")
        project("productname").and("total"),

    );
AggregationResults<Product> groupResults 
        = mongoTemplate.aggregate(agg, Product.class,Result.class);
    List<Result> result = groupResults.getMappedResults();

 public class Result {

     private String productname;

      private long total;

   }

edited Aug 29, 2018 at 17:41

answered Aug 27, 2018 at 5:53

gaurav singh

1,4261 gold badge16 silver badges27 bronze badges

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

2 Comments

Nico Haase Over a year ago

Can you explain your solution? Which parts are relevant, and why do you think they solve the problem?

Big data Hadoop dev. Over a year ago

gaurav thanx for this , but i required spring boot mongo aggregation logic not mongo query .. mongo i know.

Hardik Ralhan · Accepted Answer · 2021-12-31 09:26:24Z

0

@GetMapping("/group")
public List<ProductCount> groupByName() {

// grouping by prductName
  GroupOperation groupOperation = 
         Aggregation.group("productName").count().as("count");
// projection operation
 ProjectionOperation projectionOperation = 
 Aggregation.project("count").and("productName").previousOperation();      
// sorting in ascending
 SortOperation sortOperation = 
        Aggregation.sort(Sort.by(Sort.Direction.ASC, "count"));
// aggregating all 3 operations using newAggregation() function
 Aggregation aggregation = 
        Aggregation.newAggregation(groupOperation,projectionOperation 
        ,sortOperation);
// putting in a list 
// "products" is collection name
 AggregationResults<ProductCount> result =
        mongotemplate.aggregate(aggregation, "products", 
        ProductCount.class);    
 return result.getMappedResults();
    }

$ make ProductCount class in model package

public class ProductCount {
  private String productName;
  private int count;

  #getters
  #setters

edited Dec 31, 2021 at 9:26

answered Dec 31, 2021 at 9:13

Hardik Ralhan

112 bronze badges

1 Comment

Community Over a year ago

As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

In Spring boot Mongodb find group by count by using Aggregation framework

2 Answers 2

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related