You have two options: 1) perform 4 quesries
rows=db(query_first).select()+db(query_second).select() +db(query_third).select()+db(query_others).select(orderby=criteria) 2) perform one query and sort them in memoery rows=db(...).select().sort(lambda row: yoursortingfunction(row)) On Jun 9, 5:38 am, Jason Brower <encomp...@gmail.com> wrote: > I have a field in my database that I would like to order in a particular > way. It is string. > > Could I order the item by stating what should be first second third, and > then the rest can be alphabetical. > In particular. > db.orders, orderby=db.orders.status > That way I can get all the "Completed" and the second could be "At the > door" and so on? > BR, > Jason Brower
