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
13006	Add order_by with sql LOWER() support	Raydiation	nobody	"I have to order a huge list of of names and when i order by the the title of an artist, uppercase A comes after lowercase z, which i dont want. To fix it i currently order with the extra() method which is very inconveniant. I thought of something like: 

{{{
result = MusicCollection.objects.all().order_by(artists__lower, songs__lower)
}}}

where 
{{{
__lower
}}}
 triggers the sql LOWER() function on the column.

This would take less effort than to use the long extra statement every time."	New feature	closed	Database layer (models, ORM)	1.1	Normal	fixed	sql,order,lower	George Vilches hv@…	Accepted	0	0	0	0	0	0