Using Criteria Builder with Projections

Something I had to dig around for today was how to perform a sum on a table using Criteria Builder. It seems that it is treated a bit different than a normal query would be. Here is an example of what I tried and failed at:

	def c = Transaction.createCriteria()
	def cnt = c.get {
	projections {
	sum("amount")
	}
	and {
	eq("status", k)
	eq("transactionType", transactionType)
	ge("dateTimeProcessed", cal1.getTime())
	le("dateTimeProcessed", cal2.getTime())
	}
	}

view raw incorrect_projections.groovy hosted with ❤ by GitHub

After playing around with it a bit, I found that I can't use the 'and' closure. I revised the code to the following and it worked:

	def c = Transaction.createCriteria()
	def cnt = c.get {
	projections {
	sum("amount")
	}
	eq("status", k)
	eq("transactionType", transactionType)
	ge("dateTimeProcessed", cal1.getTime())
	le("dateTimeProcessed", cal2.getTime())
	}

view raw correct_projections.groovy hosted with ❤ by GitHub