[Django] #28335: Add query expressions support for models meta ordering

4 views
Skip to first unread message

Django

unread,
Jun 23, 2017, 10:17:37 AM6/23/17
to django-...@googlegroups.com
#28335: Add query expressions support for models meta ordering
-------------------------------------+-------------------------------------
Reporter: cypreess | Owner: nobody
Type: | Status: new
Uncategorized |
Component: | Version: 1.11
Uncategorized | Keywords: model ordering F
Severity: Normal | query expressions
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
I am trying to use F() statement inside ordering in model:

{{{
class MyModel(models.Model):
owner = models.ForeignKey(settings.AUTH_USER_MODEL, blank=True,
null=True)
created = models.DateTimeField(db_index=True, auto_now_add=True)

class Meta:
ordering = (F('owner_id').asc(nulls_first=True), 'created')
}}}

and this causes an error when running manage.py:

{{{
[...]
File "/[...]/lib/python3.6/site-packages/django/db/models/base.py", line
1651, in <genexpr>
fields = ((f[1:] if f.startswith('-') else f) for f in fields)
AttributeError: 'OrderBy' object has no attribute 'startswith'
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/28335>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

Django

unread,
Jun 25, 2017, 12:11:19 PM6/25/17
to django-...@googlegroups.com
#28335: Add query expressions support for models meta ordering
-------------------------------------+-------------------------------------
Reporter: cypreess | Owner: Dima
| Kudosh
Type: New feature | Status: assigned
Component: Database layer | Version: 1.11
(models, ORM) |
Severity: Normal | Resolution:
Keywords: model ordering F | Triage Stage:
query expressions | Unreviewed
Has patch: 0 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Dima Kudosh):

* cc: Dima Kudosh (added)
* status: new => assigned
* component: Uncategorized => Database layer (models, ORM)
* owner: nobody => Dima Kudosh
* type: Uncategorized => New feature


--
Ticket URL: <https://code.djangoproject.com/ticket/28335#comment:1>

Django

unread,
Jun 26, 2017, 11:13:10 AM6/26/17
to django-...@googlegroups.com
#28335: Add query expressions support for models meta ordering
-------------------------------------+-------------------------------------
Reporter: cypreess | Owner: Dima
| Kudosh
Type: New feature | Status: closed

Component: Database layer | Version: 1.11
(models, ORM) |
Severity: Normal | Resolution: duplicate

Keywords: model ordering F | Triage Stage:
query expressions | Unreviewed
Has patch: 0 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Tim Graham):

* status: assigned => closed
* resolution: => duplicate


Comment:

Duplicate of #26257

--
Ticket URL: <https://code.djangoproject.com/ticket/28335#comment:2>

Django

unread,
Sep 5, 2017, 7:32:52 PM9/5/17
to django-...@googlegroups.com
#28335: Add query expressions support for models meta ordering
-------------------------------------+-------------------------------------
Reporter: cypreess | Owner: Dima
| Kudosh
Type: New feature | Status: closed
Component: Database layer | Version: 1.11
(models, ORM) |
Severity: Normal | Resolution: fixed

Keywords: model ordering F | Triage Stage:
query expressions | Unreviewed
Has patch: 0 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Tim Graham <timograham@…>):

* resolution: duplicate => fixed


Comment:

In [changeset:"093fd479d6be1790c6dc174f9df3a895b50e8a2f" 093fd47]:
{{{
#!CommitTicketReference repository=""
revision="093fd479d6be1790c6dc174f9df3a895b50e8a2f"
Fixed #28335 -- Allowed query expressions in Meta.ordering.
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/28335#comment:3>

Reply all
Reply to author
Forward
0 new messages