How to sort by multiple columns with sorting = "local"?

[nghiemhd]

Hi everyone,

I have a json data with these fields: EmployeeId, Name, DOB, Title
I want to sort data in client and by multiple columns (with order by sortedColumn, DOB, EmployeeId)
For example:
If sort by Name, data will order by Name, DOB, EmployeeId
If sort by Title, data will order by Title, DOB, EmployeeId
If sort by DOB, data will order by DOB, EmployeeId

How can I do this? Thank you very much

[paramvir]

There is inbuilt support for multiple column sorting in Pro version.

http://paramquery.com/pro/api#option-dataModel-sortIndx


In base version you have to implement multiple column sorting yourself by listening to beforeSort event and returning false.

http://paramquery.com/api#event-beforeSort