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>

I already have what they say, I want to disable ordering, i.e. ascending-descending — Devanshi Parikh
– Devanshi Parikh, Commented Nov 22, 2016 at 8:05

davidkonrad · Accepted Answer · 2016-11-25 16:14:30Z

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, 2016 at 16:14

answered Nov 22, 2016 at 12:43

davidkonrad

85.7k17 gold badges211 silver badges273 bronze badges

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

Comments

jithin john · Accepted Answer · 2019-04-16 14:40:30Z

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, 2019 at 14:40

jithin john

5724 silver badges12 bronze badges

Comments

Sushil · Accepted Answer · 2020-04-12 18:58:57Z

2

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
    }
  }

answered Apr 12, 2020 at 18:58

Sushil

2,5102 gold badges29 silver badges27 bronze badges

Collectives™ on Stack Overflow

How to disable initial Ordering of data in Angular Datatables?

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related