Grails执行查询HQL-无法定位参数

Question

我很少在查询中使用use ecuteQuery，因为有时我遇到这个错误，我不知道如何修复它，这是我的代码：

use(TimeCategory) {
        def referenceDate = new Date() - 101.year
        println '============================= '+referenceDate
            def cancelledSlots = RegistrantTestingCenterExamSchedule.executeQuery("""select rt.registrant.emailAddress from RegistrantTestingCenterExamSchedule as rt 
                where rt.registrant.firstName in(select i.firstName from Individual i) and rt.registrant.lastName in(select i.lastName from Individual i) and 
                rt.registrant.middleName in(select i.middleName from Individual i) and rt.registrant.birthDate in(select i.birthDate from Individual i) or 
                rt.registrant.seniorCitizen = false or rt.registrant.birthDate >=:refDate""",[refDate: referenceDate])            
}

我得到了这个错误消息:找不到命名参数[refDate]我试图删除不需要与我声明的参数(和rt . register . birth date)进行比较的条件

Answer 1

根据手册，三重引用的多行字符串不适用于 HQL（请参阅多行查询部分）。尝试使用行继续符：

executeQuery("select rt.registrant.emailAddress \
from RegistrantTestingCenterExamSchedule as rt \
.... \
or rt.registrant.birthDate >= :refDate", [refDate : referenceDate])