On Aug 17, 10:52 am, fishwebby <pastelva...@gmail.com> wrote: > 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)
This should work. Could be that you need a index? > > 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
