Estoy usando Spring Data Mongodb en mi proyecto y refiero las siguientes clases para mi consulta sobre la agrupación de los resultados:
Clase de estudiante:
@Document(collection = "student") public class Student { @Id private String id; private String firstName; private String lastName; //other fields //getters & setters }Resultados del estudiante (dto):
public class StudentResults { private String firstName; private List<String> studentIds; //I need List<Student> here public String getFirstName() { return firstName; } public void setFirstName(String firstName) { this.firstName = firstName; } public List<String> getStudentIds() { return studentIds; } public void setStudentIds(List<String> studentIds) { this.studentIds = studentIds; } }Clase StudentServiceImpl:
public class StudentServiceImpl implements StudentService { @Autowired private MongoTemplate mongoTemplate; public List<StudentResults> findStudentsGroupByFirstName() { TypedAggregation<Student> studentAggregation = Aggregation.newAggregation(Student.class, Aggregation.group("firstName"). addToSet("id").as("studentIds"), Aggregation.project("studentIds"). and("firstName").previousOperation()); AggregationResults<StudentResults> results = mongoTemplate. aggregate(studentAggregation, StudentResults.class); List<StudentResults> studentResultsList = results.getMappedResults(); return studentResultsList; } } Usando el código anterior, puedo recuperar List<String> studentIds con éxito, pero necesito recuperar List<Student> students usando Aggregation.group() ? ¿Puede usted ayudar?
Cambie su parte TypedAggregation a continuación y agregue el campo de students a StudentResults
TypedAggregation<Student> studentAggregation = Aggregation.newAggregation(Student.class, Aggregation.group("firstName"). push("$$ROOT").as("students"));$$ROOT empujará todo el documento.
Actualizar:
TypedAggregation<Student> studentAggregation = Aggregation.newAggregation(Student.class, Aggregation.group("firstName"). push(new BasicDBObject ("_id", "$_id").append ("firstName", "$firstName").append ("lastName", "$lastName")).as("students"));