id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
2247	Foreign key ordering bug	timosa2@…	Adrian Holovaty	"The following kind of model where you would like to order objects indirectly using a foreign key results errors like in below.

The model:

{{{
class Day(models.Model):
    date        = models.DateField()
    description = models.CharField(maxlength=20)

    class Admin:
        pass
    class Meta:
        ordering = ['date', 'description']

class DayRow(models.Model):
    day = models.ForeignKey(Day)

    class Admin:
        pass
    class Meta:
        ordering = ['day']

class Slot(models.Model):
    day_row = models.ForeignKey(DayRow)
    info    = model.CharField(maxlength=50)
    
    class Admin:
        pass
    class Meta:
        ordering = ['day_row']
}}}

The error:

{{{
Traceback (most recent call last):
File ""/usr/lib/python2.4/site-packages/django/core/handlers/base.py"" in get_response
  74. response = callback(request, *callback_args, **callback_kwargs)
File ""/usr/lib/python2.4/site-packages/django/contrib/admin/views/decorators.py"" in _checklogin
  54. return view_func(request, *args, **kwargs)
File ""/usr/lib/python2.4/site-packages/django/views/decorators/cache.py"" in _wrapped_view_func
  40. response = view_func(request, *args, **kwargs)
File ""/usr/lib/python2.4/site-packages/django/contrib/admin/views/main.py"" in change_list
  739. cl = ChangeList(request, model)
File ""/usr/lib/python2.4/site-packages/django/contrib/admin/views/main.py"" in __init__
  570. self.get_results(request)
File ""/usr/lib/python2.4/site-packages/django/contrib/admin/views/main.py"" in get_results
  628. result_list = list(self.query_set)
File ""/usr/lib/python2.4/site-packages/django/db/models/query.py"" in __iter__
  94. return iter(self._get_data())
File ""/usr/lib/python2.4/site-packages/django/db/models/query.py"" in _get_data
  412. self._result_cache = list(self.iterator())
File ""/usr/lib/python2.4/site-packages/django/db/models/query.py"" in iterator
  163. cursor.execute(""SELECT "" + (self._distinct and ""DISTINCT "" or """") + "","".join(select) + sql, params)
File ""/usr/lib/python2.4/site-packages/django/db/backends/util.py"" in execute
  12. return self.cursor.execute(sql, params)

  ProgrammingError at /admin/xyz/dayrow/
  ERROR: missing FROM-clause entry for table ""xyz_day"" SELECT ""xyz_dayrow"".""id"",""xyz_dayrow"".""day_id"" FROM ""xyz_dayrow"" ORDER BY ""xyz_day"".""date"" ASC
}}}

"	defect	closed	Database layer (models, ORM)	dev	normal	duplicate			Unreviewed	0	0	0	0	0	0