Thanks for the response Villas. Do note that my use of fields=['id','last_name','first_name', ... is based on examples in the book . I tried your suggestions, sadly, I'm getting a KeyError error message. W2P complaining about the "db.auth_user" table names... Have you tried this out yourself and is it working in your system?
As for orderby, the use of built-in python functions (i.e. orderby=db.auth_user.last_name.lower() ...) are documented in the book. So I suppose the issue is something else? /r On May 4, 11:45 pm, villas <villa...@gmail.com> wrote: > I should have also said that I think the fields should be fields and > not strings: > i.e. > fields = [db.auth_user.id, db.auth_user.last_name, ....] > > On May 4, 2:47 pm, niknok <nikolai...@gmail.com> wrote: > > > > > > > > > I'm using v1.94.6 and retrieving ordered search results from crud.search > > always produces a list sorted by id > > > Tried various combinations: > > > orderby=db.auth_user.last_name > > orderby=db.auth_user.birth_date > > orderby=db.auth_user.last_name.lower()|db.auth_user.first_name.lower() > > > Attached is a screenshot with orderby set to last entry above. > > > The code I use is: > > > form,rows = crud.search(db.auth_user > > ,query=(db.auth_user.account_type==0)&(db.auth_user.id!=auth.user.id) > > ,fields=['id','last_name','first_name','middle_name','birth_date'] > > ,orderby=db.auth_user.last_name.lower()|db.auth_user.first_name.lower() > > ,queries=['equals','contains','starts with','ends with','greater > > than','less than']) > > > Did I miss anything or doing something wrong here? > > > /r > > Nik > > > crud.search-sorting.png > > 103KViewDownload
