通过使用ExcecuteQuery计数和组

问题描述：

enter image description here 通过使用ExcecuteQuery计数和组

如何通过activationDate获得组的计数数？

我试图此查询

def mapQuery6= new HashMap() 

def query6 = "SELECT count(al.id) as totalCount,al.activationDate from Card al where and TO_DAYS(al.activationDate) > TO_DAYS(:from) and TO_DAYS(al.activationDate) <= TO_DAYS(:to) GROUP BY al.activationDate " 

mapQuery6.from = params.from 
def to = new Date().parse('dd/MM/yyyy HH:mm:ss', params.to+ " 05:00:00") 
to.setDate(to.getDate() + 1) 

mapQuery6.to = to 

println "query 6 = "+query6 

def activecard = Card.executeQuery(query6,mapQuery6)[0] 

println "activecard = "+activecard

如果使用IAM的结果时，我印刷是

activecard = [1, 2014-06-17 20:27:11.0]

和，如果我想是这样

enter image description here

结果没有group by al.activationDate的结果是

activecard = [6, 2014-06-27 20:27:11.0]

，所以我想GE每月累计数.. 例如2014-07-XX有3个计数，2014-06-XX 2，和2014-05-XX仅1

答

尝试分组按月像

GROUP BY MONTH(al.activationDate)

通过使用ExcecuteQuery计数和组

相关推荐