Laravel: How can i sorting data using ajax in datatables?

Question

I am getting data of invoice table but i want to sort data in desc This is my code:

var oTable = $('#ks-datatable').DataTable({
    'processing': false,
    'serverSide': true,
    "searching": false,
    /*"bLengthChange": false,*/
    'ajax': '{{route('invoice.index')}}',

    columns: [
        {data: 'id', name: 'id'},
        {data: 'client_name', name: 'client_name'},
        {data: 'invoice_number', name: 'invoice_number'},
        {data: 'date', name: 'date'},
        {data: 'created_at', name: 'created_at'},
        {data: 'amount', name: 'amount'},
        {data: 'action', name: 'action', searchable: false},
    ]
});

you'll probably need to sort this in the server side.

danblack
– danblack

2018-10-01 04:30:24 +00:00
Commented Oct 1, 2018 at 4:30 — danblack
– danblack, Commented Oct 1, 2018 at 4:30

Priyanka khullar · Accepted Answer · 2018-10-01 08:53:57Z

2

use order in datatable :

 "ordering":'true'
 "order": [columnNumber, 'orderType'],

Example

 ....
 "ordering":'true'
 "order": [0, 'desc'],

Your code will be:

var oTable = $('#ks-datatable').DataTable({
    'processing': false,
    'serverSide': true,
    "searching": false,
    /*"bLengthChange": false,*/
    'ajax': '{{route('invoice.index')}}',
    "ordering":'true',
    "order": [0, 'desc'],
    columns: [
        {data: 'id', name: 'id'},
        {data: 'client_name', name: 'client_name'},
        {data: 'invoice_number', name: 'invoice_number'},
        {data: 'date', name: 'date'},
        {data: 'created_at', name: 'created_at'},
        {data: 'amount', name: 'amount'},
        {data: 'action', name: 'action', searchable: false},
    ]
});

edited Oct 1, 2018 at 8:53

Priyanka khullar

5171 gold badge5 silver badges26 bronze badges

answered Oct 1, 2018 at 4:33

Dhruv Raval

1,5831 gold badge10 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

Laravel: How can i sorting data using ajax in datatables?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related