How to set formula in grails domain class?

Question

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)')
    }
}

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

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?

Note that the formula expressed in the ORM DSL is SQL so references to other properties should relate to the persistence model not the object model, which is why the example is wrong being that it refers to appointmentTime and not APPOINTMENT_TIME — Tyler Rafferty, Feb 22 '18 at 00:19

Hussain Fakhruddin · Accepted Answer · 2018-07-14T05:55:52.367

5

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

http://gorm.grails.org/6.1.x/hibernate/manual/#derivedProperties

edited Jul 14 '18 at 05:55

answered May 09 '14 at 07:08

Hussain Fakhruddin

3,202
4
25
36

Do you mean this fields will be persistent with DB? – sanghavi7 May 09 '14 at 10:30
2

Derived properties are not persisted, at least not directly. See http://grails.org/doc/latest/guide/GORM.html#derivedProperties. – Jeff Scott Brown May 09 '14 at 10:45
1

No it wont be if its a derived property, but it has to be non transient to be used by criteria or dynamic finder. – Hussain Fakhruddin May 09 '14 at 10:45
1

@HussainFakhruddin you can update the link http://gorm.grails.org/6.1.x/hibernate/manual/#derivedProperties ;) – genuinefafa Jul 13 '18 at 04:00

How to set formula in grails domain class?

1 Answers1

Linked