(Quick Reference)
list
Purpose
Lists instances of the domain class.
Examples
// list everything
def results = Book.list()// list 10 results
def results = Book.list(max: 10)// list 10 results, offset by 100
def results = Book.list(max: 10, offset: 100)// list 10 results, offset by 100, orderd by title in descending order
def results = Book.list(max: 10, offset: 100, sort: "title", order: "desc")// list all books, eagerly fetching the authors association
def results = Book.list(fetch: [authors: "eager"])
Description
Parameters:
max
- The maximum number to list
offset
- The offset from the first result to list from
order
- How to order the list, either "desc"
or "asc"
sort
- The property name to sort by
ignoreCase
- Whether to ignore the case when sorting. Default is true
.
fetch
- The fetch policy for the object's associations as a Map
readOnly
- true if returned objects should not be automatically dirty-checked (simlar to read()
)
fetchSize
- number of rows fetched by the underlying JDBC driver per round trip
flushMode
- Hibernate FlushMode
override, defaults to FlushMode.AUTO
timeout
- query timeout in seconds