Sorting on hidden columns and passing direction
Sorting on hidden columns and passing direction
![psib3r](https://secure.gravatar.com/avatar/bfb3ea47ac113d768390ec3ab79fec41/?default=https%3A%2F%2Fvanillicon.com%2Fbfb3ea47ac113d768390ec3ab79fec41_200.png&rating=g&size=120)
Hi, can't seem to work this out, I have a table [Surname], [Firstname], [Surname Firstname], [DOB]
Surname and Firstname are hidden, what I want it to do is sort on Surname (either asc or desc as normal) then firstname (always asc) when i click on the [Surname Firstname] column. Is this possible?
A bit like if it was SQL it would be like "order by Surname @escdesc, Firstname"
This discussion has been closed.
Answers
A forum search would find the answer.
http://legacy.datatables.net/usage/columns#iDataSort