I am facing a problem with projections in createCriteria

Question

I am facing a problem to get the required result from this closure

def authors{
    results = Message.createCriteria().list {
        projections {
            author{
                groupProperty('id', 'authorId') // 2nd param is alias
                property('username', 'username')
            }
        }

        and{
            ...
            ...
        }
    }

    [authors:results]
}

I want to show this list on my gsp page and wants to access the values using aliases (while above criteria is returning a list of arrays)

score 6 · Accepted Answer · answered May 07 '13 at 01:07

6

Use resultTransformer(CriteriaSpecification.ALIAS_TO_ENTITY_MAP).

import org.hibernate.criterion.CriteriaSpecification
Message.createCriteria().list {
    resultTransformer(CriteriaSpecification.ALIAS_TO_ENTITY_MAP)
    projections {
        author{
            groupProperty('id', 'authorId')
            property('username', 'username')
        }
    }
}

All projections must have aliases. Otherwise the resulting map will contain nulls.

answered May 07 '13 at 01:07

Diamond Hands

803
1
10
16

For the hint that all projections must have a alias. I was going nuts as to why I was getting nulls. – Vishnoo Rath Sep 19 '16 at 13:50

score 3 · Answer 2 · answered Aug 17 '11 at 05:44

You can try this

def authors{
    results = Message.createCriteria().list {
        projections {
            author{
                groupProperty('id') 
                property('username')
            }
        }

        and{
            ...
            ...
        }
    }
    List authors = results.collect{record -> [authorId : record[0], username:record[1]}
    [authors:authors]   }

I am facing a problem with projections in createCriteria

2 Answers2