I have this records:
I need to group this records by class_id, so i will be one array with two positions.
const quizAbertos = await Database .select('*') .from('student_quiz_historics') .where('student_id', idEstudante) .where('execution_back_status', 'Enviado Perguntas') .groupBy('class_id')
But i’m getting:
select “student_quiz_historics”.* from “student_quiz_historics” where “student_id” = $1 and “execution_back_status” = $2 group by “student_quiz_historics”.“class_id” - column “student_quiz_historics.id” must appear in the GROUP BY clause or be used in an aggregate function