Spring Boot development involved querying only nested objects in a specified domain, but the methods in the Query/Criteria class that are now used can only fetch the entire document/line: { "_id": { "$oid": "<Some Object Id>" }, "identifier": "string1", "createTime":…
I have the following collection: [ { "_id": 1, "favorite": { "color": "red", "foods": { "fruits": "banana", "fastfood": [ "burger", "sandwich" ] } } }, { "_id": 2, "favorite": { "color": "green", "foods": { "noodles": "ramen", "fastfood": [ "fries", "burger",…
I have this document: { "id" : "001", "items" : { "persons" : [ { "city" : "London", "color" : "red", "status" : "1" }, { "city" : "Paris", "color" : "blue", "status" : "0" } ], "animals" : […
I've a MongoDB collection that contains records with a field called createdAt, I want to get the last createdAt in the previous month of a given date using mongoTemplate aggregation in a spring boot application. example of a record: {…
I'm using the query bellow to get max date (field named extractionDate) in a collection called KPI, and since I'm only interested in the field extractionDate: @Override public Mono<DBObject> getLastExtractionDate(MatchOperation matchOperation,ProjectionOperation projectionOperation) { return Mono.from(mongoTemplate.aggregate( newAggregation( matchOperation, projectionOperation, group().max(EXTRACTION_DATE).as("result"), project().andExclude("_id")…