Re: Ordering a queryset on a reverse foreign key's attribute

2013-08-01 Thread Daniele Procida
On Thu, Aug 1, 2013, Simon Charette wrote: >>From a quick look I'd also expect `order_by('-children__date')` to work. > >Can you provide the generated SQL query and some results? I have in fact raised a ticket about this which shows the generated se

Re: Ordering a queryset on a reverse foreign key's attribute

2013-08-01 Thread Simon Charette
>From a quick look I'd also expect `order_by('-children__date')` to work. Can you provide the generated SQL query and some results? Le jeudi 1 août 2013 09:58:25 UTC-4, Daniele Procida a écrit : > > I have an Event model: > > class Event(Model): > parent = models.ForeignKey('self',

Ordering a queryset on a reverse foreign key's attribute

2013-08-01 Thread Daniele Procida
I have an Event model: class Event(Model): parent = models.ForeignKey('self', related_name='children') date = models.DateField() My question is: given a queryset of this model, how can I order it based on the Events' children's dates so that (say) Events with child Events wit