order without orderable

capeck

I understand that ordering of data is done with datatables settings, not the editor. I need to order based on a hidden column and not have any visible columns able to be ordered. (It is a large table and keeping the order consistent is important for editing) . I set the order on the hidden column and set all the visible columns to orderable: false. Looks like this:

                 "order": [[ 19, 'asc' ]],
                columnDefs: [
                    { orderable: false, targets: [0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18] }
                ],

Is this a reasonable solution or should I be going about it differently? Thanks.

colin

Yep, that's a good way to go, the only change I'd make is to use _all for columnDefs.targets, see here,

Colin

capeck

Thanks for the help!