Find max value in table column

[Chopo87]

Hello

I am creating a version control domain class:

class VersionControl {

	Date dateCreated
	Long versionNumber

	Long getLatestVersionNumber() {
		//return largest versionNumber
	}

}

I would like to add a query to the largest version number stored:

Long getLatestVersionNumber()

. In SQL this query would look more or less as follows:

SELECT TOP 1 MAX(versionNumber) FROM VersionControl

The function MUST return the value as a long.

What is the correct way to do this in grails?

Thanks

 

[dave]

You can use criteria and a projection however probably the fastest method is simply to try :

VersionControl.executeQuery( 'select max(versionNumber) from VersionControl' )

 

[Chopo87]

Thank you dave, your solution works perfectly. For those interested in the criteria based solution, see this alternative solution Arturo gave me on stackoverflow (http://stackoverflow.com/questions/12783318/grails-find-max-value-in-table-column)

 

[dave]

No problem & thanks for sharing the Criteria based alternative