On Oct4, 5:22pm, GhostRider <kenneth.t.lundst...@gmail.com> wrote: > I´m working on an ordering system and trying to make av overview of > orders. It would look about this, > > Customer | Product 1 .... Product x | Pickup place | Order status | > Some tools > > The overview is working, data is collected from different tables. > Problem is that customer wants to sort the table in different why, > sometimes based on customer name, sometimes on product and sometimes > on pickup place. > > Any ideas on how to do this? > > I would like to make the table headers as links och sort the table > based on that. I was thinking about collecting all data in a temporary > table and make the sorting in SQL. > > Kenneth
The client-side jquery datatables plugin has exactly the sort- triggered-by-table-header feature. In server side, I used a slightly different approach. Because in my order system, the user does not really want to "sort" orders by pickup place, but just wants to know which orders need to be prepared in ONE GIVEN pickup place. So I just provide a search-by-pickup-place feature. Hope you get the idea. Sincerely, Iceberg --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---