Grails GORM - Find all objects with an excellent property value

Question

I am using Grails, and I am trying to figure out how to get all the different values ​​of a property of a domain class. In other words, I am looking for all the individual values ​​for a column. However, I'm not sure how to translate this into a GORM statement, the preferred criterion.

I am open to anyone that gives me a list of domain classes (each of which has a different meaning for the property in question), and I collect all the property values. Or something that gives me various property values ​​directly.

Answer 1

I think all you have to do is use projections and distinct . According to the documentation, this will provide you with a list of different property values ​​from your domain class.

 def results = MyDomain.withCriteria { projections { distinct("theDistinctProperty") } } 

Answer 2

I use the forecast criteria and groupProperty to get the different values ​​that I use. This code is now in production.

 def criteria = Item.createCriteria() def items = criteria { projections { groupProperty "product", "product" } order "product" //remeber import import org.hibernate.transform.AliasToEntityMapResultTransformer in order to get alias property resultTransformer(AliasToEntityMapResultTransformer.INSTANCE) }