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
25316	Can't use order_by and values(_list) together after annotating	Adrian Wielgosik	varun naganathan	"Example:


{{{
# model

from django.db import models
class Table(models.Model):
    value = models.IntegerField()

# tests

from django.test import TestCase
from testapp.models import Table
from django.db.models import IntegerField, Case, Value, When
class Test1(TestCase):
    def test_1(self):
        query = Table.objects.annotate(
            other=Case(
                When(value=11, then=Value(1)),
                output_field=IntegerField()
            ),
        ).order_by('other', 'value').values('id')

        print query

}}}

The error is:

{{{
AttributeError: 'WhereNode' object has no attribute 'resolve_expression'
}}}"	Bug	closed	Database layer (models, ORM)	1.8	Normal	fixed	annotate, order_by	josh.smeaton@…	Ready for checkin	1	0	0	0	0	0