hibernate - 在Grails 3中按WHERE子句过滤hasMany结果

Question

我有这样的grails域类

class ClassRoom {

    Integer Id
    String classRoomName
    Date dateDeleted

    static hasMany = [students: Student]

}

class Student {
     String studentName
     Date dateDeleted
}

假设我从ClassRoom中打印了classRoom 1的所有学生。 println ClassRoom.findByIdAndDateDeletedIsNull(1).students还将打印所有具有dateDeleted的学生。
有什么方法可以过滤掉具有dateDeleted SET的记录？

Answer 1

以下将返回给您的学生列表

ClassRoom.executeQuery("""
        select s 
          from ClassRoom c
          join c.students s
         where c.id = :id 
           and c.dateDeleted is null
           and s.dateDeleted is null
""", [id: id])