Default sorting on multi-column

[dqninh09@gmail.comParticipant]

Hi All,

I have a table that has the following columns: State, city, name, address, etc…

I can make the table grouped by State. But I also want it to be, by default, order by City and Name.

How do I specify that in the jqxDataTable?

Thanks.

[Peter StoevKeymaster]

Hi dqninh09,

Sorting by multiple columns is not supported so this unfortunately cannot be achieved.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[dqninh09@gmail.comParticipant]

How about just one column? Can it be sorted by Name within the State group?

[Peter StoevKeymaster]

Hi dqninh09,

You can sort by one column: http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxdatatable/javascript-datatable-sorting.htm?arctic

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[dqninh09@gmail.comParticipant]

Hi Peter,

It works, with a deep gliche. :). If you have a datatable that is grouped, the sorting of a column will mess up the group.

For example, if you have a datasource that has the following columns:

State
City
Name
Address

And you have a datatable using the above datasource, grouped by State. If you don’t have a sorted column, and the the group is displayed in order with states that has A like Arkansas, Alaska, Az first. But, if you have a sorted column, for example, on the Name, and then the order of the State group is messed up badly.

Thanks.

[Author]

Posts