django - Sorting related records in recursive relation -


i have following class recursive foreign key. questions , answers storing in same table.
question, type='q'
answer type = 'a'

i wan tot sort questions date in desc, dependent answer has sorted in asc order. how can in django?

class talk(models.model):     user = models.foreignkey(user)     destination = models.foreignkey(destination)     text = models.textfield()     type = models.charfield(max_length=30)     sup = models.foreignkey('self', blank=true, null=true, related_name='child')     created_dt = models.datetimefield(auto_now_add=true)     thumb_up = models.integerfield()     thumb_down = models.integerfield()  class meta:         ordering = ["-created_dt"]  

questions = talk.objects.filter(type='q') 

gets question in default ordering. answers sorted specific question, lets newest one, use order_by:

question = questions[0]  sorted_answers = talk.objects.filter(sup=question).order_by('created_dt') 

or

question.child.order_by('created_dt') 

which looks funny because of used related_name


Comments