How to disable initial Ordering of data in Angular Datatables?

Question

I am using angular datatables and I have only one column.

When I bind it, the data comes in an ascneding order, while I want to display it in the order I recived it.

Can someone please help.

Controller :

        var vm = this;
        vm.dtOptions = DTOptionsBuilder.newOptions()
        .withButtons([
            'print',
            'pdfHtml5',

        ]);
        vm.dtColumnDefs = [
            DTColumnDefBuilder.newColumnDef(0).notSortable()
        ];

HTML :

  <div ng-controller="formViewController as frmView">
    <table datatable="ng" dt-options="frmView.dtOptions" dt-column-defs="frmView.dtColumnDefs" class="row-border hover">
        <thead>
            <tr>
                <td>
                    {{Title}}
                </td>
            </tr>
        </thead>
        <tbody>
            <tr ng-repeat="plugin in newArray track by $index">
                <td>
                    //Content
                </td>
            </tr>
        </tbody>
    </table>
</div>

http://stackoverflow.com/questions/31027497/in-angular-js-how-to-disable-column-sort-feature-for-selected-columns — Vinod Louis, Nov 22 '16 at 05:03
I already have what they say, I want to disable ordering, i.e. ascending-descending — Devanshi Parikh, Nov 22 '16 at 08:05

davidkonrad · Accepted Answer · 2016-11-25T16:14:30.523

13

Look at order, formerly known as aaSorting. Add

.withOption('order', [])

to your dtOptions. The default value of order is [[0, 'asc']], setting it to [] will prevent dataTables from making an initial sort on the first column after initialisation.

edited Nov 25 '16 at 16:14

answered Nov 22 '16 at 12:43

davidkonrad

83,997
17
205
265

score 2 · Answer 2 · answered Apr 16 '19 at 14:40

2

Resolved

this.dtOptions ={
 ajax:{},
 columns:[],
 order:[] //<= Use this
}

This worked for me. I tried several other ways, but thus seems to be the better solution.

answered Apr 16 '19 at 14:40

jithin john

552
4
12

score 2 · Answer 3 · answered Apr 12 '20 at 18:58

Try This

  dtOptions: DataTables.Settings = {};

  ngOnInit() {
    // table settings
    this.dtOptions = {
      pagingType: 'full_numbers',
      pageLength: 10,
      retrieve: true,
      order:[[0, 'desc']]   // '0' is the table column(1st column) and 'desc' is the sorting order
    }
  }

How to disable initial Ordering of data in Angular Datatables?

3 Answers3

Related