#31481 closed Bug (fixed)
Admin crash when using functions in model meta ordering of o2o primary key.
Reported by: | Gergely Kalmár | Owned by: | nobody |
---|---|---|---|
Component: | contrib.admin | Version: | dev |
Severity: | Normal | Keywords: | |
Cc: | Triage Stage: | Unreviewed | |
Has patch: | no | Needs documentation: | no |
Needs tests: | no | Patch needs improvement: | no |
Easy pickings: | no | UI/UX: | no |
Description
Let's assume we have two models as follows:
from django.db import models class ExampleObject(models.Model): some_field = models.CharField(max_length=50) class Meta: ordering = [models.functions.Lower('some_field')] class ExampleExtension(models.Model): example_object = models.OneToOneField( ExampleObject, primary_key=True, on_delete=models.PROTECT )
If I register the latter model in admin:
from django.contrib import admin from myapp import models admin.site.register(models.ExampleExtension)
I get the following error:
FieldError at /admin/myapp/exampleextension/ Cannot resolve keyword 'some_field' into field. Choices are: example_object, example_object_id
If I remove the Lower
model function it works as expected. Also, the ordering generally seems to work fine in all other places, except in the admin interface. Am I doing something silly?
Change History (5)
comment:1 by , 5 years ago
Resolution: | → fixed |
---|---|
Status: | new → closed |
Summary: | Using model functions in model meta ordering fails in admin → Admin crash when using functions in model meta ordering of o2o primary key. |
Version: | 3.0 → master |
comment:2 by , 5 years ago
Thank you! Am I right that the patch is not released yet? Is there a workaround (besides patching Django locally) in the meantime?
comment:3 by , 5 years ago
Am I right that the patch is not released yet?
Yes, it's not released. It will be included in Django 3.1.
Is there a workaround (besides patching Django locally) in the meantime?
You can move ordering
to the ExampleExtension
, e.g.
class ExampleExtension(models.Model): ... class Meta: ordering = [models.functions.Lower('example_object__some_field')]
follow-up: 5 comment:4 by , 4 years ago
Hm, it seems that Django 3.1 is coming only around August - would that be possible to move this small patch into a patch release on 3.0 instead? The workaround doesn't really work that nicely because I need the ordering to apply also to ExampleObject instances (e.g. for listing) and not only when using them through ExampleExtension (in this hypothetical case). This issue keeps breaking the admin interface and it would take quite some work to work around it in all places I would have to :(.
comment:5 by , 4 years ago
Replying to Gergely Kalmár:
Hm, it seems that Django 3.1 is coming only around August - would that be possible to move this small patch into a patch release on 3.0 instead?
No. This is not a regression in Django 3.0. Per our backporting policy this means it doesn't qualify for a backport to 3.0.x. See https://docs.djangoproject.com/en/3.0/internals/release-process/ for more details.
Thanks for this ticket. It was fixed in 013147fae2b9168b06c495aa78c10725cab294cd (I'm not marking this as a duplicate because it's a different scenario).