derniere_classe.classe_code as codeClasse,
eleve.nom||' '||eleve.prenom as nomPrenomEleve,
censeur.nom||' '||censeur.prenom as nomPrenomCenseur,
+ type_punition.libelle as typePunition,
type_incident.libelle as typeIncident,
count(*) OVER() as nbrPunitions
from
derniere_classe.classe_code as codeClasse,
eleve.nom||' '||eleve.prenom as nomPrenomEleve,
censeur.nom||' '||censeur.prenom as nomPrenomCenseur,
+ type_punition.libelle as typePunition,
type_incident.libelle as typeIncident,
count(*) OVER() as nbrPunitions
from
sqlQuery.addScalar('codeClasse', Hibernate.STRING)
sqlQuery.addScalar('nomPrenomEleve', Hibernate.STRING)
sqlQuery.addScalar('nomPrenomCenseur', Hibernate.STRING)
+ sqlQuery.addScalar('typePunition', Hibernate.STRING)
sqlQuery.addScalar('typeIncident', Hibernate.STRING)
sqlQuery.addScalar('nbrPunitions', Hibernate.LONG)
List resultats = sqlQuery.list()
result['punitionsInfo'] = resultats
- result['nbPunitionsInfo'] = resultats ? resultats[0][5] : 0
+ result['nbPunitionsInfo'] = resultats ? resultats[0][6] : 0
return result
}