Named Queries in Grails 1.2
April 6th, 2010 by Micha KopsThey built a nice new feature in Grails 1.2 called “named queries“. Named queries can be defined in a domain class as static properties and support the criteria builder syntax.
Contents
Examples
package testapp class User { String name int iq int age static namedQueries = { dumbUsers { int referenceIq = 60 lt 'iq' , referenceIq } nameStartsWith { letter -> like 'name', '${letter}%' } midAges { between('age', 20, 40) } } } // count dumb users println User.dumbUsers.count() // print amount of users, usernames starting with an 'a' User.nameStartsWith('a').count()
Resources
- Grails Reference
- Criteria API Documentation
- Grails Download
- Articles on hasCode.com tagged with “Grails”
Article Updates
- 2015-03-03: Table of contents added.
package testapp
class User {
String name
int iq
static namedQueries = {
dumbUsers {
int referenceIq = 60
lt ‘iq’ , referenceIq
}
nameStartsWith { letter ->
like ‘name’, ‘${letter}%’
}
}
}
Tags: criteria builder, gorm, grails, groovy, hibernate, named queries, persistence
October 7th, 2010 at 8:42 am
1.2 ;) check your title.
October 7th, 2010 at 11:30 am
thanks! :)