How to sort column by keyword?

ayxa

Hi, I am try to sort column by keyword. In last column named "status" there are "active", "inactive" & "deleted" data. I wanna sort "active" data first then "inactive" and then "deleted" .

$(document).ready(function() {
    $.getJSON("api/ItemList.json", function(data) {
        var table = $('#list').DataTable({
            data: data.Success.Body.Item,
            columns: [{
                    data: 'Category'
                },
                {
                    data: 'Attributes.name'
                },
                {
                    data: 'Inventory.0.Status'
                }
            ]
        });
    });
});

kthorngren

You would use Ortogonal Data for this. For example using columns.render you can assign numeric values to active, inactive and deleted for the sort operation to sort in the order desired.

Kevin

ayxa

Sorry, documentation not helping much

kthorngren

Here is an example:
http://live.datatables.net/yaqizefu/1/edit

Kevin