Angularjs Datatable server side pagination

Question

I'm trying to make Angularjs Datatable server side pagination in this link https://l-lin.github.io/angular-datatables/#/serverSideProcessing

So I use this code

    $scope.dtOptions = DTOptionsBuilder.newOptions()
       .withOption('ajax', {
                  dataSrc: function(json) {
                    conole.log(json)
                    json['recordsTotal'] =json.length
                    json['recordsFiltered'] = json.length
                    json['draw']=1
                    conole.log(json)
                    return json;
                  },
              url: 'api/footestrecords',
              type: 'GET'
           })
       .withOption('processing', true)
       .withOption('serverSide', true)
       .withPaginationType('full_numbers');

I added recordsTotal, recordsFiltered and row manually in dataSrc parameter

and this is json data before and after add recordsTotal, recordsFiltered and row

json data before add

[Object, Object, Object, Object, Object, Object, Object, Object,
Object,Object, Object, Object, Object, Object, Object, Object, Object,
Object, Object, Object, Object, Object, Object, Object, Object, Object,
Object, Object]

json data after add

 [Object, Object, Object, Object, Object, Object, Object, Object,
  Object, Object, Object, Object, Object, Object, Object, Object, Object,
  Object, Object, Object, Object, Object, Object, Object, Object, 
  Object,Object, Object, recordsTotal: 28, recordsFiltered: 28, draw: 1]

the probelm is pagination don't work ,data table shows all data in one page,and when I click on paging button did no action.

You made error here: conole.log

zygimantus
– zygimantus

2017-05-04 20:13:43 +00:00
Commented May 4, 2017 at 20:13 — zygimantus
– zygimantus, Commented May 4, 2017 at 20:13

halfzebra · Accepted Answer · 2016-01-18 18:47:42Z

10

Returned JSON format should be:

{
    data: [{Object},{Object},{Object},{Object}…]
    draw: "1"
    recordsFiltered: 91
    recordsTotal: 91
}

You can get a complete tutorial from here about Datatables server-side paging, sorting and filtering in angularjs

edited Jan 18, 2016 at 18:47

halfzebra

6,8154 gold badges34 silver badges47 bronze badges

answered Jan 18, 2016 at 17:49

Sourav Mondal

4356 silver badges13 bronze badges

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

Comments

zygimantus · Accepted Answer · 2017-05-07 08:21:17Z

1

Remove .dataSrc and use this option:

.withDataProp(function(json) {
  console.log(json);
  json.recordsTotal = json.response.total;
  json.recordsFiltered = json.response.total;
  json.draw = 1;
  return json.response.data;
})

Change json.response according your object.

answered May 7, 2017 at 8:21

zygimantus

3,7855 gold badges45 silver badges56 bronze badges

Comments

sam ruben · Accepted Answer · 2019-04-05 05:58:43Z

0

The return data must be list of object ["data"]=[{name:john,id:1},{name:jason,id:2}].

Try
  .withOption('ajax', {
                  dataSrc: function(data) {                 
                   return data.data;
                     }
                  })
Else,
       .withOption('ajax', {
                  "dataSrc": "data"
                  }

answered Apr 5, 2019 at 5:58

sam ruben

3753 silver badges6 bronze badges

Collectives™ on Stack Overflow

Angularjs Datatable server side pagination

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related