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 """", line 1, in 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