Hibernate mysql groupe by day whith 0 entities
- by Touhami
I have this function
i need to do that in sql (hibernate or mysql) or a java function that interpert the array of results
select DAY(affaire.docCreationDate), count(affaire.docfullName) from CRMAffaireCode.AffaireClass as affaire where affaire.docfullName like 'CRMAffaire.Affaire%' and affaire.docCreationDate = '" + startDate + " 00:00:00' and affaire.docCreationDate <= '" + endDate + " 23:59:59' GROUP BY DAY(affaire.docCreationDate)"
i have this entitie count in my table
2012-10-05 3
2012-10-06 0
2012-10-07 7
2012-10-08 13
2012-10-09 9
2012-10-10 0
2012-10-11 0
2012-10-12 3
the request return me this values
5 3
7 7
8 13
9 9
12 3
in this way i loose three lignes that have 0 as value, i need a request that return me this
5 3
6 0
7 7
8 13
9 9
10 0
11 0
12 3