flashcloud

//来自：https://blog.csdn.net/qq_16165281/article/details/98483094
import org.hibernate.criterion.CriteriaSpecification  

def index() {
        def result = CustomerScoreCard.createCriteria().list {
            resultTransformer(CriteriaSpecification.ALIAS_TO_ENTITY_MAP)
            projections {
                salProjection """
                        group_concat (fileIds) filelds,
                        MAX (CASE month WHEN '1月' THEN val ELSE O END ) 1月,