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
24592	order_by HStore Key/Value Pair	David Muller		"I am currently trying out Django 1.8's HStore implementation, but am having trouble using the ORM's order_by function.

Say I have HStore dictionaries stored in my database like

{{{
{'key': 'value', 'en-US': 'english'}
}}}

and would like to order a queryset by the strings pointed to by one particular key.

I run into 2 distinct errors trying to 'order_by' either key ('key' or 'en-US'):

1.
{{{
MyModel.objects.order_by('name__key')

/usr/local/etc/virtualenvs/gears/local/lib/python2.7/site-packages/django/db/models/sql/query.py in names_to_path(self, names, opts, allow_many, fail_on_missing)
   1427                     raise FieldError(
   1428                         ""Cannot resolve keyword %r into field. Join on '%s'""
-> 1429                         "" not permitted."" % (names[pos + 1], name))
   1430                 break
   1431         return path, final_field, targets, names[pos + 1:]

FieldError: Cannot resolve keyword 'key' into field. Join on 'name' not permitted.
}}}


2.
{{{
MyModel.objects.order_by('name__en-US')

/usr/local/etc/virtualenvs/gears/local/lib/python2.7/site-packages/django/db/models/sql/query.py in add_ordering(self, *ordering)
   1717                 errors.append(item)
   1718         if errors:
-> 1719             raise FieldError('Invalid order_by arguments: %s' % errors)
   1720         if ordering:
   1721             self.order_by.extend(ordering)

FieldError: Invalid order_by arguments: ['name__en-US']
}}}

Is ordering by a particular key/value pair not something the ORM supports (or plans on supporting)?  


"	New feature	closed	contrib.postgres	dev	Normal	duplicate	hstore postgres order_by value		Accepted	0	0	0	0	0	0