namedQueries
Purpose
The namedQueries
static property defines named queries. Named queries support the criteria builder syntax. See the section on the Criteria Builder in the user guide for more information.
Examples
class Publication {String title String author Date datePublished Integer numberOfPages
static namedQueries = { recentPublications { def now = new Date() gt 'datePublished', now - 365 }
oldPublicationsLargerThan { pageCount -> def now = new Date() lt 'datePublished', now - 365 gt 'numberOfPages', pageCount }
publicationsWithBookInTitle { like 'title', '%Book%' }
recentPublicationsWithBookInTitle { // calls to other named queries… recentPublications() publicationsWithBookInTitle() } } }
// get all recent publications… def recentPubs = Publication.recentPublications.list()// get up to 10 recent publications, skip the first 5… def recentPubs = Publication.recentPublications.list(max: 10, offset: 5)
// get a single recent publication def recentPub = Publication.recentPublications.get()
// get the number of recent publications… def numberOfRecentPubs = Publication.recentPublications.count()
// get a recent publication with a specific id… def pub = Publication.recentPublications.get(42)
// get all recent publications where title = 'Some Title' def pubs = Publication.recentPublications.findAllWhere(title: 'Some Title')
// get a recent publication where title = 'Some Title' def pub = Publication.recentPublications.findWhere(title: 'Some Title')
// dynamic finders are supported def pubs = Publication.recentPublications.findAllByTitle('Some Title')
// get all old publications with more than 350 pages def pubs = Publication.oldPublicationsLargerThan(350).list()
// get all old publications with more than 350 pages // and the word 'Grails' in the title def pubs = Publication.oldPublicationsLargerThan(350).findAllByTitleLike('%Grails%')
// get all recent publications with 'Book' in their title def pubs = Publication.recentPublicationsWithBookInTitle().list()
The list
method on named queries supports the same attributes as the static list
method added to domain classes (sort, order, ignoreCase, fetch etc...). See the list docs for details.
Note that calling something likePublication.recentPublications.get(42)
is not the same as calling something likePublication.get(42)
. The former will only return aPublication
if thePublication
with id 42 meets all the criteria defined in therecentPublications
named query.
Named criteria support listDistinct()
:
class PlantCategory {Set plants String name
static hasMany = [plants: Plant]
static namedQueries = { withPlantsInPatch { plants { eq 'goesInPatch', true } } } }
class Plant { boolean goesInPatch String name }
PlantCategory.withPlantsInPatch.listDistinct()
Named criteria support additional criteria being supplied at invocation time in the form of a criteria closure:
// get all recent publications with author names beginning with Tony or Phil… def books = Publication.recentPublications { or { like 'author', 'Tony%' like 'author', 'Phil%' } }// get the number of recent publications with // author names beginning with Tony or Phil… def numberOfBooks = Publication.recentPublications.count { or { like 'author', 'Tony%' like 'author', 'Phil%' } }
Named criteria may be chained together. When criteria are chained together, the query will be generated as if all of the chained criteria had been combined in a single criteria closure.
// recent publications with 'Book' in the title def books = Publication.recentPublications.publicationsWithBookInTitle.list()// old publications with more than 500 pages and with 'Book' in the title def books = Publication.oldPublicationsLargerThan(500) .publicationsWithBookInTitle .list()
When a named query involves a domain class relationship and the relationship class defines a named query, that named query may be accessed directly as a method call. An example:
class Author {static hasMany = [publications: Publication]
static namedQueries = { authorsWithRecentPublications { publications { // invoking a named query defined in the Publication class… recentPublications() } } } }
class Publication {Author author
static namedQueries = { recentPublications { def now = new Date() gt 'datePublished', now - 10 } } }