Projections Grails

crit1.groovy

Link.withCriteria {
    votes {
        projections {
            groupProperty("link")
            sum("score")
        }
    }
}

critSort.groovy

Link.withCriteria {
    createAlias('votes', 'v')
    projections {
        groupProperty('v.link')
        sum('v.score', 'score')
    }
    order 'score', 'desc'
}

LinkStatistics.groovy

class LinkStatistics {

    static belongsTo = [link: Link]
    Integer score
    Date dateCreated

    static mapping = {
        table("v_link_statistics")
        link(fetch: FetchMode.EAGER)
        version(false)
    }

}

newQuery.groovy

LinkStatistics.list(sort: 'score', order: 'desc')

newSorting.groovy

LinkStatistics.withCriteria {
    createAlias('link','l')
    order('score', 'desc')
    order('dateCreated', 'desc')
    order('id', 'desc')
}

view.sql

CREATE VIEW  v_link_statistics AS 
SELECT l.id, l.id as link_id, sum(nvl(v.score,0)), l.date_created
FROM link l LEFT JOIN vote v ON v.link_id = v.id 
GROUP by l.id;