Hi, I've got the following query to select auth_users from a list of IDs, then ordered by name:
users = db(db.auth_user.id.belongs((1,2,3))).select(orderby = db.auth_user.first_name) which works fine in sqlite, but when deployed to gae the orderby doesn't work. Do belongs and orderby not work together in gae? NB. There does seem to be an issue about it, but the page (about the fifth result with this Google search: http://www.google.es/search?q=web2py+belongs+orderby+gae) on the issue tracker gives a 502 error at the moment so I can't read it...) I could get around it by sorting in Python afterwards, e.g. users = (db(db.auth_user.id.belongs((1,2,3))).select()).sort(lambda row:row.first_name) would this be computationally expensive for a large dataset or is this an acceptable workaround? Many thanks Dave
