Convert MongoDB query into Spring MongoDB syntax

Question

Hello I am unable to convert the following mongoDB query into spring query, i have tried multiple ways, but did not get the result.

db.getCollection('FarmerCropDataLog').aggregate([
        {
            "$match" : 
            {
                "cropData.crop" : "RICE",
                 "creationTime" :
                  {
                      $lt  : 1551447981473.0
                  }
            }
        },
        {
            "$group" :
            {
                _id : null,
                "average" :{
                        $avg : "$cropData.cropPrice"
                },
                "max" :{
                        $max : "$cropData.cropPrice"
                },
                "min":{
                        $min : "$cropData.cropPrice"
                }
            }
        }
    ])

I have written follwing code, but unable to think about next step.

Query query = new Query();

query.addCriteria(Criteria.where(FarmerCropDataLog.Constants.CROP_LOG).elemMatch(Criteria.where(CropData.Constants.CROP).is(getComparisonSheet.getCrop())));

query.addCriteria(Criteria.where(FarmerCropDataLog.Constants.CREATION_TIME).gt(Year * DIFF));

Mani · Accepted Answer · 2019-03-01 21:08:01Z

8

Have you ever thought about using MongoDB compass? It will make your work very simple.

Open MongoDB compass connect to your instance
Aggregation tab, construct your pipeline
click on the 3 dots(...) next to save pipeline option
Select export to language and select Java
Your query is ready

Here is the java query

Arrays.asList(match(and(eq("cropData.crop", "RICE"), lt("creationTime", 1551447981473.0d))), group(new BsonNull(), avg("average", "$cropData.cropPrice"), max("max", "$cropData.cropPrice"), min("min", "$cropData.cropPrice")))

answered Mar 1, 2019 at 21:08

Mani

1,5371 gold badge13 silver badges19 bronze badges

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

1 Comment

xavi4_4_4 Over a year ago

Where can I find Aggregation tab?

Van_Cleff · Accepted Answer · 2019-03-01 19:54:16Z

If you've used JpaRepository then it's easy to relate that you can create an interface and extends MongoRepository just like with JpaRepository and it provides some simple method, and you don't need the implement it.

you can use (for example consider A Person with First and Last name)

MongoDB JSON based query methods and field restriction

public interface PersonRepository extends MongoRepository<Person, String>

@Query(value="{ 'firstname' : ?0 }", fields="{ 'firstname' : 1, 'lastname' : 1}")
List<Person> findByThePersonsFirstname(String firstname);
}

Geo-spatial repository queries

public interface PersonRepository extends MongoRepository<Person, String>

  // { 'location' : { '$near' : [point.x, point.y], '$maxDistance' : distance}}
  List<Person> findByLocationNear(Point location, Distance distance);
}

Read the Spring document here for MongoDB repositories

Collectives™ on Stack Overflow

Convert MongoDB query into Spring MongoDB syntax

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related