如何在grails域类中设置公式? [英] How to set formula in grails domain class?

问题描述

我正在尝试在域类中编写公式，这有助于我创建条件.

I am trying to write formula in my domain class which helps me in creating criteria.

class MyClass {
    //some fields
    Date appointmentTime
    String ddmmyy
    int year
    int month
    int day
    static transients = [
        'ddmmyy',
        'year',
        'month',
        'day'
    ]
    static mapping= {
        ddmmyy formula('DATE_FORMAT(appointmentTime)')
        year formula('YEAR(appointmentTime)')
        month formula('MONTH(appointmentTime)')
        day formula('DAYOFMONTH(appointmentTime)')
    }
}

每当我尝试在条件中使用此字段时，都会引发错误，即无法解析"myClass"的属性"ddmmyy".

Whenever I am trying to use this fields in my criteria it throws error i.e. can not resolve property 'ddmmyy' of 'myClass'.

MyCriteria是:

MyCriteria is:

Date myDate = Calender.instance.time

def results = MyClass.createcriteria().list{
    lt('appointmentTime', date+1)
    ge('appointmentTime', date)
    projections {
        groupProperty('ddmmyy')
        count('id')
    }
}

有人知道为什么我要为此例外吗?

Any idea why I am getting an exception for this?

推荐答案

您需要使这些字段成为非临时性以便在条件中使用.请参阅参考文件

You need to make these fields non transient to use in criteria. See reference document

http://gorm.grails.org/6.1.x/休眠/手动/#derived属性

这篇关于如何在grails域类中设置公式?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！