SQLFORM.gris sorting by multiple fields

[Yebach]

Hello

Is it possible to have a sort order by second key in SQLFORM.grid.

Table:

First_name    Last_name   Skill

John             Doe              Medic

Marry            Smith           Medic

Tim               Doe             Surgeon

Marry            Obama         Surgeon

If e.g. I would like to sort by skill and then after last_name

Thank you

[Niphlod]

• orderby is used as default ordering for the rows. See DAL chapter (multiple fields are possible).

[Vid Ogris]

And If I want the sorting to be done on user request. 

so he/she can sort by last_name or skill separately or skill and one clicked on skill it is also sorted by last name?

I hope I am clear enough?

Thank you

--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to a topic in the Google Groups "web2py-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/fVHm8E9g1is/unsubscribe.
To unsubscribe from this group and all its topics, send an email to web2py+un...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Lep pozdrav 

Vid Ogris

[Niphlod]

as soon as one clicks on a column, it'll be ordered ONLY by that column. user-driven multi-column ordering is not implemented.

[Vid Ogris]

Ok thank you

I guess javascript function would be the solution?