grails - 如何在grails的 parent 的子女名单上创建标准

Question

我有父域和子域

  class Parent{
        static hasMany = [childs: Child]
  }

  class Child{

  }

在数据库中

  Parent_Id  Parent_Age  Parent_Name
      1        20          AAAA
      2        25          BBBB

   Child_id  Child_Age   Child_Name  Parent_Id(F.K.)
      1        2           00000       1
      2        6           11111       1
      3        5           22222       1 
      4        3           33333       2
      5        4           44444       2
      5        9           55555       2

现在我有了父对象。

    def parentInstance = Parent.get(1);
    def childsList     = parentInstance?.childs  ---> //from this list here  
                                                      //i want to get             
                                                     // only those childs  
                                                     //whose age is greater  
                                                     //than or equal to 3.  
                                                             Or
                                                     // greater than or 
                                                     //equal to 5.

是否可以在查询列表中执行此操作。

Answer 1

像这样尝试:

Parent parentInstance = Parent.get(1);

List<Child> childList = Child.createCriteria().list(){
     parent{
         eq("id", 1 as Long)
     }

     or{
         ge("age", 3)

         ge("age", 5)
    }

}