I got it to work with static html data as shown in this jsfiddle:
by specifying
aoColumns: {"sType": "natural"}
where when I sort the first column it shows rows in right (natural-sorted) order:
SIR_1_SIL_CGG_2011_224_SILAC1b_IMAC_Fr1
SIR_2_SIL_CGG_2011_224_SILAC1b_IMAC_Fr1
SIR_3_SIL_CGG_2011_224_SILAC1b_IMAC_Fr1
SIR_10_SIL_CGG_2011_224_SILAC1b_IMAC_Fr1
...
But then I want to apply natural sort to this same datatable where data is fetched server-side, the code where I invoke the data table is the same as in the jsfiddle adding the serverside related things:
$ ->
$("#sir_table").dataTable
sPaginationType: "full_numbers"
bProcessing: true
bServerSide: true
aoColumns: [{"sType": "natural"}, {"sType": "natural"}, {"sType": "natural"} ]
aaSorting: [[ 1, "asc" ]]
sAjaxSource: $('#sir_table').data('source')
The DataTable shows alright but the natural-sort does not work as it should (like in the jsfiddle, as above). Instead rows are displayed:
SIR_1_SIL_CGG_2011_224_SILAC1b_IMAC_Fr1
SIR_10_SIL_CGG_2011_224_SILAC1b_IMAC_Fr1
...
SIR_19_SIL_CGG_2011_224_SILAC1b_IMAC_Fr1
SIR_2_SIL_CGG_2011_224_SILAC1b_IMAC_Fr1
SIR_20_SIL_CGG_2011_224_SILAC1b_IMAC_Fr1
Why is this happening? Is natural-sort plugin even compatible with server side processing? How should I implement it?