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
13363	extra fields of Model.objects.extra() can't be filtered	fetzig		"{{{
sepp = SomeModel.objects.extra(select={'hiho': """"""(6371 * acos(cos( radians(%f) ) 
* cos( radians( geo_lat ) ) * cos( radians( geo_long ) - radians(%f) ) 
+ sin( radians(%f) ) * sin( radians( geo_lat ) ) ))"""""" % (latitude, longitude, latitude)})
sepp.filter(hiho__lt=30)
}}}

throws an exception:
{{{
Traceback (most recent call last):
  File ""<console>"", line 1, in <module>
  File ""/django/db/models/query.py"", line 550, in filter
    return self._filter_or_exclude(False, *args, **kwargs)
  File ""/django/db/models/query.py"", line 568, in _filter_or_exclude
    clone.query.add_q(Q(*args, **kwargs))
  File ""/django/db/models/sql/query.py"", line 1131, in add_q
    can_reuse=used_aliases)
  File ""/django/db/models/sql/query.py"", line 1026, in add_filter
    negate=negate, process_extras=process_extras)
  File ""/django/db/models/sql/query.py"", line 1194, in setup_joins
    ""Choices are: %s"" % (name, "", "".join(names)))
FieldError: Cannot resolve keyword 'hiho' into field. Choices are: ...all the fields of the model
}}}

"		closed	Database layer (models, ORM)	dev		wontfix	queryset extra filter		Unreviewed	0	0	0	0	0	0