"Fossies" - the Fresh Open Source Software Archive

Member "grails-core-5.2.4/grails-docs/src/test/resources/docs/ref/Database Mapping/sort.html" (14 Sep 2022, 60128 Bytes) of package /linux/www/grails-core-5.2.4.tar.gz:


Caution: In this restricted "Fossies" environment the current HTML page may not be correctly presentated and may have some non-functional links. You can here alternatively try to browse the pure source code or just view or download the uninterpreted raw source code. If the rendering is insufficient you may try to find and view the page on the grails-core-5.2.4.tar.gz project site itself.

(Quick Reference)

sort

Purpose

Customizes the default property to sort by for query results.

Examples

class Book {
    ...
    static mapping = {
        sort "releaseDate"
    }
}

Description

Usage: sort(string/map)

By default results are sorted by creation date, and you can specify the column to order by in a query:

def results = Book.list(sort:"title")

However, you can also configure the default sort property:

static mapping = {
    sort "title"
}

in which case the sort argument is no longer needed. You can also control the sort order:

static mapping = {
    sort title: "desc" // or "asc"
}