Django Extract Queryset From Manytomany With Through Field

Say we have those models: class A(models.Model): field = models.ManyToManyField(B, through='C') class B(models.Model): value = models.CharField() class C(models.Model):

Solution 1:

If you put a an ordering on model C, all queryset on C would obey that order:

classC(models.Model):

    classMeta:
        ordering = ('order', )

Now if you want B objects related to A, you could sort the Bs based on C's ordering:

b_results = a.fields.order_by('c')

Or if the order_by('c') is not clear enough, you could change your model to be:

class C(models.Model):
    a = models.ForeignKey(A, related_name='a_relationship')
    b = models.ForeignKey(B)
    order = models.IntegerField()

    class Meta:
        ordering = ('order', )

Then you could do:

b_results = a.fields.order_by('a_relationship')

Solution 2:

Use the C model reverse relations to do the order, e.g.

a.fields.order_by(c__order)