Grails - Combine Joins in the Criteria API Twice

Can I join an association twice in the criteria?

def criteria = User.createCriteria();
def results = criteria.list() {
    childObject1{
      eq("childObjProp","childObjProp1") 
      childObject2 {
          eq("testId", 1 as long) //User input
      }

    }
    childObject1{
      eq("childObjProp","childObjProp1_1") 
      childObject2 {
          eq("testId", 1 as long) //User input
      }

    }
}

Where childObject2data is user input, it may or may not be available. I have a solution SQL. But i needcriteria solution

This question is more related to this error.

+4
source share

All Articles