details: http://www.bx.psu.edu/hg/galaxy/rev/b1c07aa74ea1 changeset: 3308:b1c07aa74ea1 user: jeremy goecks <jeremy.goecks@emory.edu> date: Mon Feb 01 13:39:14 2010 -0500 description: Rollback case-insensitive sorting in grids because changes don'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 36a8ccff3901 -r b1c07aa74ea1 lib/galaxy/web/framework/helpers/grids.py --- a/lib/galaxy/web/framework/helpers/grids.py Mon Feb 01 11:23:51 2010 -0500 +++ b/lib/galaxy/web/framework/helpers/grids.py Mon Feb 01 13:39:14 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