Disable Ordering Columns after initialization (init complete) in datatables

Question

I would disable order possibility to user after datatables is draw. I have a datatable, and I would order a data and remove possibility, for an user, to order data manually. How can I do it?

I used below code:

table = $('#tbl-1').DataTable({
            "info": false,
            "searching": true,
            "paging": false,
            "iDisplayLength": 25,
            "lengthMenu": [[10, 25, 50, -1], [10, 25, 50, "Tutti"]],
            "language": {"url": "include/it_IT.txt"},
            "order": [[1,"desc"]],              
            //"ordering": false,
            //"orderFixed": {"pre": [ 1, "desc" ]},                             
             "fnInitComplete": function(oSettings, json) {
                    //alert( 'DataTables has finished its initialisation.' );
                    this.fnFilter("<?php echo $_POST['search'];?>");                        
                  },
            }).on('init.dt', function (e, settings, data) {
                wrappa(); //after custom function
            });

http://www.datatables.net/forums/discussion/7377/disable-all-sorting-after-init — markpsmith
– markpsmith, Commented Dec 18, 2014 at 11:10
Addressing some potential confusion. If you're looking to disable auto-sorting of your (e.g. server-side sorted) table after datatables init, but keep the sorting functionality enabled for intentional use, see here. If you want to disable the sorting completely, see below for an answer. — ᴍᴇʜᴏᴠ
– ᴍᴇʜᴏᴠ, Commented Jan 22, 2019 at 8:31

Rick · Accepted Answer · 2017-10-11 01:56:22Z

1

old post but still not handled by dt api. Removing the events won't work if wanting to temporarily disable sorting. Instead use jquery to add and later remove a class onto each th, and in this class specify "pointer-events: none".

answered Oct 11, 2017 at 1:56

Rick

911 silver badge5 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

zardilior · Accepted Answer · 2019-01-24 16:39:02Z

0

Due to the fact that the API does not have a way to do this, I would suggest the following approach

Declare your table at first

var table = $('#myTable').DataTable();

Re-Initialize your dataTable with to disable ordering

//Destroy your table before
table.destroy();
$('#myTable').dataTable( {
  "ordering": false
} );

reference: https://datatables.net/reference/option/ordering

edited Jan 24, 2019 at 16:39

answered Dec 21, 2014 at 22:36

zardilior

3,0181 gold badge27 silver badges31 bronze badges

3 Comments

Valix85 Over a year ago

this isn't correct because i need to ordering first time, and only after ordering i must disable..

davidkonrad Over a year ago

if you set ordering : false on the column OP wants to prevent the user to be able to sort on, he will loose his own ordering, eg "order": [[1,"desc"]], as well.

ᴍᴇʜᴏᴠ Over a year ago

This will disable the ordering completely

Collectives™ on Stack Overflow

Disable Ordering Columns after initialization (init complete) in datatables

2 Answers 2

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related