¿Cómo obtener la misma fila varias veces en Grails?

How to get same row multiple times in Grails?

If subqueries or associations are used, one may end up with the same row multiple times in the result set. In Hibernate one would do a “CriteriaSpecification.DISTINCT_ROOT_ENTITY”. In Grails one can do it by just using this method. The listDistinct () method does not work well with the pagination options maxResult and firstResult.

Criteria queries are a type-safe, advanced way to query that uses a Groovy builder to construct potentially complex queries. It is a much better alternative to using a StringBuilder to dynamically construct an HQL query. Refer to the user guide section on Criteria for usage instructions. The default method; returns all matching rows.

In Grails one can do it by just using this method. The listDistinct () method does not work well with the pagination options maxResult and firstResult. If you need distinct results with pagination, we currently recommend that you use HQL. You can find out more information from this blog post .

Because that query includes pagination parameters (max and offset), this will return a PagedResultList which has a getTotalCount () method to return the total number of matching records for pagination. Two queries are still run, but they are run for you and the results and total count are combined in the PagedResultList.

Multiple List Selections. Adding the multiple attribute to allows the user to select more than one option. The user will need to hold down the ctrl or cmd key to select more than one option in the list, so you will need to add some explanatory text.

The user will need to hold down the ctrl or cmd key to select more than one option in the list, so you will need to add some explanatory text. If your list is long, it’s a good idea to set a larger size so that multiple options are visible at the same time.