jQuery DataTables with Node.js

Question

So i am trying to implement a pagination table with the datatables plugin, this is my first time using this plugin. I followed the documentation on the plugin and tried to get the values from the server through the use of Ajax, as per presented in the plugins documentation.

I seem to be getting the following error once i make the get request and i am unsure of why?

Error: Uncaught TypeError: Cannot read property 'length' of undefined

On client side i have the following code

viewReports = {
    init: function(){
        $('#paginatedData').DataTable({
            "processing": true,
            "serverSide": true,
            "ajax": '/viewreports'
        });

    }
};

$(document).ready(viewReports.init);

In my server side i have the following

router.get('/viewreports', function(res, req){

    async.parallel({
        viewReports: function(callback){
            restCall('/rest/bugbounty/latest/message/searchReport', 'POST', parameters, function(data){
                callback(null, data);
            }); 
        }
    }, function(err, result){
        if(!err){
            res.send(result.viewReports);
            res.render('viewreports');
        }
    });
});

Returned JSON:

{ reportList: [ { reportID: 'EIBBP-448', eBayUserID: ' ', reportStatus: 'New', summary: 'BugBounty Report created by Raj', lastUpdatedDate: '2015-06-15 01:05', createdDate: '2015-06-15 01:05', paypalLoginID: '[email protected]' } ], searchStatus: 'Success', eBayUserID: '', errorCode: '0', rowCount: '6', pageNumber: '1', paginationValue: '1', paypalLoginID: '[email protected]' }

It would be great to know if there is anyone who has worked with node.js server side processing for datatables

In server-side processing mode your server-side code should return data in the JSON format as described here. Please post the JSON file that your server returns. — Gyrocode.com
– Gyrocode.com, Commented Jun 15, 2015 at 2:26
so there is no specific file where i am saving my json data to, but upon rendering the route '/viewreports' i am able to see the following value on the console { reportList: [ { reportID: 'EIBBP-448', eBayUserID: ' ', reportStatus: 'New', summary: 'BugBounty Report created by Raj', lastUpdatedDate: '2015-06-15 01:05', createdDate: '2015-06-15 01:05', paypalLoginID: '[email protected]' } ], searchStatus: 'Success', eBayUserID: '', errorCode: '0', rowCount: '6', pageNumber: '1', paginationValue: '1', paypalLoginID: '[email protected]' } — Raj
– Raj, Commented Jun 15, 2015 at 2:30
Your response is not correct for server-side processing mode, please read Server-side processing for more details and data format. And yes, you need to return string in JSON format. — Gyrocode.com
– Gyrocode.com, Commented Jun 15, 2015 at 2:36
Please Check answer of pankaj kumar https://stackoverflow.com/questions/50731153/jquery-datatable-with-nodejs-mysql/78165849#78165849 — pankaj kumar
– pankaj kumar, Commented Mar 15, 2024 at 10:44

davidkonrad · Accepted Answer · 2015-06-15 11:02:03Z

6

You need to define dataSrc and columns.data - the following should work :

var table = $('#example').DataTable({
    processing: true,
    serverSide: true,
    ajax: {
        url: "/viewreports",
        dataSrc: "reportList"
    },    
    columns: [ 
        { data : "reportID" },
        { data : "eBayUserID" },
        { data : "reportStatus" },
        { data : "summary" },
        { data : "lastUpdatedDate" },        
        { data : "createdDate" },        
        { data : "paypalLoginID" }
   ]     
});

on an empty table :

<table id="example"></table>

dataSrc to specify what the array holding row items is named (cause of "Cannot read property 'length' of undefined")
columns.data to map item properties to columns

answered Jun 15, 2015 at 11:02

davidkonrad

85.7k17 gold badges211 silver badges273 bronze badges

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

Comments

Danny Sofftie · Accepted Answer · 2017-11-02 10:06:40Z

0

You simply don't have to bother with the server side processing. I used a simple way to trick dataTables initialization.

First, you will need to fetch the data you want to display in the table through your most preferred way, after you have confirm that data displays well, now head to where you initialize dataTables and make it so that it delays before initialization.

setTimeout(() => {
    $('#yourtable').dataTable({
        // datatables customization options
    });
}, 100)

For example, in my case I gave it a delay of 100ms, and it works like a charm.

answered Nov 2, 2017 at 10:06

Danny Sofftie

1,0611 gold badge9 silver badges17 bronze badges

Collectives™ on Stack Overflow

jQuery DataTables with Node.js

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related