# Models
{{{
class Application(models.Model):
package_name = models.CharField(max_length=128, null=False,
blank=True)
package_version_code = models.IntegerField(blank=True)
package_version_name = models.CharField(max_length=64, null=False,
blank=True)
label = models.CharField(max_length=64, null=False, blank=True)
class Meta:
ordering = ['label', 'package_version_code']
class Profile(models.Model):
applications = models.ManyToManyField(
'applications.Application',
related_name='application_%(class)s',
blank=True
)
class Device(models.Model):
profile = models.ForeignKey(
Profile,
related_name='devices',
blank=True,
null=True
)
}}}
The error is:
[[Image(https://i.imgur.com/JbUyRQJ.png)]]
--
Ticket URL: <https://code.djangoproject.com/ticket/28705>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
* Attachment "JbUyRQJ.png" added.
* component: Uncategorized => Database layer (models, ORM)
Comment:
Could you add a `tests.py` file that demonstrates the issue (and/or
replace the screenshot in the description)? The screenshot isn't
particularly friendly for someone trying to reproduce this since they have
to retype everything.
Did you read the
[https://docs.djangoproject.com/en/dev/topics/db/aggregation
/#aggregations-and-other-queryset-clauses aggregation topic guide] to
ensure that none of the documented issues there are the cause of the
behavior?
--
Ticket URL: <https://code.djangoproject.com/ticket/28705#comment:1>
Comment (by Tomer Chachamu):
It looks like this section explains the behaviour:
https://docs.djangoproject.com/en/1.11/topics/db/aggregation/#interaction-
with-default-ordering-or-order-by
Maybe you want to use `.annotate(...).order_by('label', 'latest')`
instead?
--
Ticket URL: <https://code.djangoproject.com/ticket/28705#comment:2>
* status: new => closed
* resolution: => needsinfo
Comment:
Also, if you can provide the output that you expected for each of the
queries, that would help us understand the issue :)
--
Ticket URL: <https://code.djangoproject.com/ticket/28705#comment:3>