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
Post a Comment