How to sort on state

fpakay

EG: Charlotte, NC

How can I sort on the state as in the example above.
I would also like to sort on last name. EG: John Doe

kthorngren

For either one you can create a sorting plugin or you can use Orthogonal data to set the sorting value to the state or lastname.

Kevin

fpakay

Thanks Kevin.

fpakay

Looked at the two options above, however I do not understand either. Any one have an example? That would be very much appreciated.

allan

• Example with data-order attributes.
• Similar example with Ajax sourced data.
• Custom ordering plug-in.

Allan

allan

If you post an example of what you've got at the moment we can look at how it might be best modified.

Allan

fpakay

This is a typical datagrid where I would like to sort on last name.

kthorngren

Here is an example of sorting by last name:
https://live.datatables.net/yuwosuwu/1/edit

It uses Orthogonal data to manipulate the original data to the data to sort on for the sort operation. For example:

      render: function (data, type, row) {
        if (type === 'sort') {
          return data.split(' ')[1];
        }
        return data;
      }

You can do something similar with the state.

Kevin