grails - 使用 'between'的DetachedCriteria中的错误

Question

仅当我在 DetachedCriteria 的关联中使用'之间的''时，才会发生错误:

错误:

org.hibernate.QueryException: could not resolve property: execution_alias1 of: ExecutionService

条件:

new DetachedCriteria(Service).build {
    execution {
        between('date', new Date() -1, new Date())
    }
}.list()

域类:

class Service{

   static hasOne = [execution: ExecutionService]

   static constraints = {
      execution nullable: true
   }
}

class ExecutionService {

   Date date
   static belongsTo = [servico: Servico]

   static constraints = {
      date nullable: true
      servico nullable: true
   }
}

OBS:Grails版本:3.1.8

Answer 1

当我在“构建”内部有另一个块时(例如本例中的“执行”块)，“之间”似乎不起作用。

因此，我使用该解决方案(将“之间”更改为“ge”和“le”):

new DetachedCriteria(Service).build {
    execution {
        ge 'date', new Date() -1
        le 'date', new Date()
    }
}.list()