Re: [web2py] How to sort a smartgrid with your own custom sorted id list

Have you tried the orderby option of the smartgrid? Example of conctent: orderby = dict(t_prj_doc_item= [ db.t_prj_doc_item.f_sequence, db.t_prj_doc_item.id]), Le mardi 23 juin 2020 à 00:48:54 UTC+2, roge...@gmail.com a écrit : > The only thing that comes to mind is to put your sort data into th

Re: [web2py] How to sort a smartgrid with your own custom sorted id list

The only thing that comes to mind is to put your sort data into the database so you have something to sort on. If it is a single user app then it's easy - add a new column called sortid and put your custom sort order their. Multi user needs a second table to join on which might mess with smart gri

[web2py] How to sort a smartgrid with your own custom sorted id list

Hi all, How to sort a smartgrid with your own custom sorted id list? Say I have a id list of the query and I have a sorting functions that returns a sorted id list, how would I make smartgrid to commit to the ordering instead of sorting by ids by default? Thanks, rama -- Resources: - http://