columns based on a queryset

[mezitax]

How can I generate a table with an x number of columns based on a queryset? I explain:

class Assignment(models.Model):
	name = ...

class Student(models.Model):
	first_name = ...

class Calification(models.Model):
	student = models.ForeignKey('Student', related_name="calification_of_student")
	assignment = models.ForeignKey('Assignment', related_name="calification_of_assignment")

I need to see the list of students and for each assignment I want to see their qualification. The amount of assignment will be the number of columns and the cells should have the qualifications

[mezitax]

hello again, that time I resolved to create this table in html, and now after months I went back to this because I would like to have it in datatables.

What I want is that for each column, I get the grade corresponding to the instance and the assignment (column).

class Califications_Of_Subject_List_Table(Datatable):
	number = columns.TextColumn("#", sources=[])
	last_name = columns.TextColumn(sources=["last_name"])
	first_name = columns.TextColumn(sources=["first_name"])
	def get_calification_value(self, instance, *args, **kwargs):
		"""return calification for each assignment for student, i need the assignment"""
		try:
			calification = Calification.objects.get(student=instance, assignment=???)
		except ObjectDoesNotExist:
			calification = None
		return calification
		
	def __init__(self, *args, **kwargs):
		""" create columns for each assignment published in subject"""
		super(Califications_Of_Subject_List_Table, self).__init__(*args, **kwargs)
		subject_slug = kwargs.pop('subject_slug', None)
		assignments = Assignment.objects.filter(subject__slug=subject_slug, status="publish").order_by("id")
		for assignment in assignments:
			self.columns[assignment] = columns.TextColumn(assignment.pk, sources=["assignments_of_student__califications_of_assignment__calification"], processor=self.get_calification_value)

How can I get the value of the assignment (column) to use in a filter inside the processor? I thought about sending the assignment as args but init doesn't know the instance yet At this point I am lost, someone to give me a hand?