Skip to content
Snippets Groups Projects

[fix] add ordering by year to student revenue query

Merged lgtg20 requested to merge fix-issue-975 into development
1 file
+ 1
0
Compare changes
  • Side-by-side
  • Inline
@@ -142,6 +142,7 @@ studentRevenueApp.get('/', rqf.parse(), rqf.build(), (req, res, next) => {
@@ -142,6 +142,7 @@ studentRevenueApp.get('/', rqf.parse(), rqf.build(), (req, res, next) => {
.field(`SUM(receitas) / SUM(matriculas_publicas_mais_conveniada) / 12`, 'total_receita_aluno_mes_publica_mais_conveniada')
.field(`SUM(receitas) / SUM(matriculas_publicas_mais_conveniada) / 12`, 'total_receita_aluno_mes_publica_mais_conveniada')
.where(`${whereCondition}`)
.where(`${whereCondition}`)
.group('receitas.ano')
.group('receitas.ano')
 
.order('receitas.ano')
}
}
}
}
Loading