please visit this site for more
info
https://stackoverflow.com/questions/59764028/how-to-use-filtering-data-while-using-distinct-method-in-django
I hope my title is enough to understand what I mean, please help me on this
problem guys.
[image: data.PNG]
When I tried this:
"" id_list =
grade.objects.filter(Teacher=m.id).values_list('Students_Enrollment_Records_id',flat=True).distinct()
""
I use `distinct()` to eliminates duplicate rows of Students Enrollment
Record from the query results but I wonder why the result is like this:
[image: badresult.PNG]
What should I do to show the Students name not that QuerySet in my html?
This is my current **views.py**:
id_list =
grade.objects.filter(Teacher=m.id).values_list('Students_Enrollment_Records_id',flat=True).distinct()
print(id_list)
grades =
grade.objects.filter(Students_Enrollment_Records_id__in=id_list)
print(grades)
This is my **models.py**:
class grade(models.Model):
Teacher = models.ForeignKey(EmployeeUser, related_name='+',
on_delete=models.CASCADE,
null=True, blank=True)
Grading_Categories = models.ForeignKey(gradingCategories,
related_name='+', on_delete=models.CASCADE,
null=True, blank=True)
Subjects = models.ForeignKey(Subject, related_name='+',
on_delete=models.CASCADE, null=True)
Students_Enrollment_Records =
models.ForeignKey(StudentsEnrolledSubject, related_name='+',
on_delete=models.CASCADE, null=True)
Average = models.FloatField(null=True, blank=True)
**UPDATE**
when I tried this
piste =
grade.objects.filter(Teacher_id=m.id).values_list('Students_Enrollment_Records').annotate(Average=Avg('Average')).order_by('Grading_Categories').distinct()
the computation is fix but the teacher name, Subject and Name of students
didn't display but the ID is display just like this
[image: result.PNG]
this is my desire answer
[image: desireanswer.png]
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/fd4ff945-0793-46e7-aae4-caae652e62ed%40googlegroups.com.
