details: http://www.bx.psu.edu/hg/galaxy/rev/d24f0190c2a8 changeset: 3312:d24f0190c2a8 user: jeremy goecks <jeremy.goecks@emory.edu> date: Mon Feb 01 13:34:44 2010 -0500 description: Rollback case-insensitive sorting on grids because it doesn't work with postgres and mysql. diffstat: lib/galaxy/web/framework/helpers/grids.py | 7 +++++-- 1 files changed, 5 insertions(+), 2 deletions(-) diffs (19 lines): diff -r edfb84f6371e -r d24f0190c2a8 lib/galaxy/web/framework/helpers/grids.py --- a/lib/galaxy/web/framework/helpers/grids.py Sat Jan 30 16:38:12 2010 -0500 +++ b/lib/galaxy/web/framework/helpers/grids.py Mon Feb 01 13:34:44 2010 -0500 @@ -157,10 +157,13 @@ if sort_key.startswith( "-" ): sort_key = sort_key[1:] sort_order = 'desc' - query = query.order_by( func.lower( self.model_class.table.c.get( sort_key ) ).desc() ) + query = query.order_by( self.model_class.table.c.get( sort_key ).desc() ) + # Can't use lower() on timestamp objects. + #query = query.order_by( func.lower( self.model_class.table.c.get( sort_key ) ).desc() ) else: sort_order = 'asc' - query = query.order_by( func.lower( self.model_class.table.c.get( sort_key ) ).asc() ) + # See reason for not using lower() to do case-insensitive search. + query = query.order_by( self.model_class.table.c.get( sort_key ).asc() ) extra_url_args['sort'] = encoded_sort_key # There might be a current row