How to convert Mongo query in to java object

Question

I have Mongo query that I executed using NoSqlBooster(Tool) and getting expected out put. How can I convert same query in Java object.

This is Mongo Query :

db.revenue.aggregate([{
    $match: {
        hotelId: "122"
        sessionId: "dgd"
    }
}, {
    $group: {
        _id: {
             date: "$date",
             serviceOrFacilty: "$serviceOrFacilty"
         },
         "SUM(orderTotalAmount)":{
              $sum: "$orderTotalAmount"
         },
         "SUM(grandTotalAmount)":{
              $sum: "$grandTotalAmount"
         },
      }
},   {
      $project: {
          date: "$_id.date",
          serviceOrFacilty: "$_id.serviceOrFacilty",
          "SUM(orderTotalAmount)": "$SUM(orderTotalAmount)",
          "SUM(grandTotalAmount)": "$SUM(grandTotalAmount)"
      }
}])

And this is my entity/data base classs

public class RevenueReportsTemporaryStorage {
    @Id
    private String id;
    @Field(value = FIELDS.SESSSION_ID)
    private String sessionId;
    @Field(value = FIELDS.HOTEL_ID)
    private String hotelId;
    @Field(value = FIELDS.DATE)
    private String date;
    @Field(value = FIELDS.SERVICE_OR_FACILITY)
    private String serviceOrFacility;
    @Field(value = FIELDS.CATEGORY)
    private String serviceCategory;
    @Field(value = FIELDS.USER_NAME)
    private String userName
    @Field(value = FIELDS.ORDER_TOTAL)
    private Double orderTotalAmount;
    @Field(value = FIELDS.ADJUSTMENT)
    private Double adjustmentAmount;
    @Field(value = FIELDS.DISCOUNT)
    private Double discount;
    @Field(value = FIELDS.TAX)
    private Map<String, Double> taxAmountWithHead;
    @Field(value = FIELDS.GRAND_TOTAL)
    private Double grandTotalAmount;
}

By using fields, how can write the query.

Possible duplicate of Convert MongoDB query into Spring MongoDB syntax — Mani
– Mani, Commented Apr 12, 2019 at 17:20

Null Pointer · Accepted Answer · 2019-04-21 04:08:30Z

1

Try this.

Aggregation aggregation = newAggregation(
            match(Criteria.where(FIELDS.HOTEL_ID).is(hotelId).and(FIELDS.SESSSION_ID).is(uniqueId)),
            group(FIELDS.DATE,FIELDS.SERVICE_OR_FACILITY).sum(FIELDS.ORDER_TOTAL).as(FIELDS.ORDER_TOTAL).sum(FIELDS.ADJUSTMENT)
                    .as(FIELDS.ADJUSTMENT).sum(FIELDS.DISCOUNT).as(FIELDS.DISCOUNT).sum(FIELDS.GRAND_TOTAL)
                    .as(FIELDS.GRAND_TOTAL),
            sort(Sort.Direction.ASC, previousOperation(),FIELDS.DATE,FIELDS.SERVICE_OR_FACILITY));
    AggregationResults<RevenueReportsTemporaryStorage> groupResults = mongoTemplate.aggregate(aggregation,
            RevenueReportsTemporaryStorage.class, RevenueReportsTemporaryStorage.class);
    return groupResults.getMappedResults();

answered Apr 21, 2019 at 4:08

Null Pointer

2752 gold badges7 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

How to convert Mongo query in to java object

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related