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 10256 values() and values_list() either include all or no columns from the extra(select=) clause Russell Keith-Magee Russell Keith-Magee "By way of example, this is what 1.0.X produces: {{{ >>> Book.objects.extra(select={'a':'name','b':'price','c':'pages'}).values('name','pages','a') [{'a': u'Book 1', 'c': 11, 'b': Decimal(""11.11""), 'name': u'Book 1', 'pages': 11}, ... >>> Book.objects.extra(select={'a':'name','b':'price','c':'pages'}).values('name','pages') [{'name': u'Book 1', 'pages': 11}, ... }}} That is, if you don't explicitly mention an extra selected column in the values() clause, they are omitted (as expected). However, as soon as you include a single extra column, _all_ extra columns are included in the returned values. Analogous behavior exists for values_list(). " closed Database layer (models, ORM) 1.0 fixed Accepted 0 0 0 0 0 0