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
2121	Invalid SQL generated when using list_filter with search_fields	noah@…	Adrian Holovaty	"I have a model as such


{{{
class Discussion(models.Model):
    topic = models.CharField(maxlength=200)
    body = models.TextField()
    person = models.ForeignKey(Person, null=False)
    team = models.ForeignKey(Team, null=False)
    
    def __str__(self):
       return self.team.__str__() + "" thread "" + self.topic
    
    class Admin:
       list_per_page = 100
       list_display = ('team', 'topic', 'person', 'body', )
       list_filter = ('team', )
       ordering = ('team', 'topic', 'person')
       search_fields = ('body', 'topic')
}}}
If I do a search for anything I get an error as such
{{{
ProgrammingError at /admin/mrt/discussion/
ERROR: missing FROM-clause entry for table ""mrt_team"" SELECT ""mrt_discussion"".""id"",""mrt_discussion"".""topic"",""mrt_discussion"".""body"",""mrt_discussion"".""person_id"",""mrt_discussion"".""team_id"" FROM ""mrt_discussion"" WHERE (((""mrt_discussion"".""body"" ILIKE '%tim%' OR ""mrt_discussion"".""topic"" ILIKE '%tim%'))) ORDER BY ""mrt_team"".""id"" ASC
}}}

Because it's trying to order by mrt_team which is not part of the select. This needs to be remedied"	defect	closed	Database layer (models, ORM)	dev	major	worksforme	sql, admin, search, list_filter, search_fields		Unreviewed	0	0	0	0	0	0