How can I render data from multiple columns into one column?

Question

I want to render the values from two different columns into my jquery datatable

https://cdn.datatables.net/1.10.16/js/jquery.dataTables.min.js
https://cdn.datatables.net/1.10.16/css/jquery.dataTables.min.css

$(document).ready(function(){

    var table = $('#table').DataTable({

         "ajax": {
                "url": "data.json",
                "dataSrc": "",
            },

         "columnDefs": [
            {
               "render": function (data, type, row) {
                   var result = 'The id is ' + data[0] + ' and the name is ' + data[1];
                        return result;
                    },
                    "targets": 0,
                },      

         ],

        "columns": [
                {
                    "data": "id"
                },
                {
                    "data": "name"
                }
            ]
    });

});

data.json:

[{
    "id": "12",
    "name": "Laura"
}]

But my result is:

The id is 12 and the name is undefined

@markpsmith But then my result is: The id is undefined and the name is undefined — peace_love
– peace_love, Commented Oct 16, 2017 at 10:30
it should be var result = 'The id is ' + row["id"] + ' and the name is ' + row["name"]; — juntapao
– juntapao, Commented Oct 16, 2017 at 10:36

juntapao · Accepted Answer · 2017-10-16 10:38:07Z

8

Please change the following:

"columnDefs": [
            {
               "render": function (data, type, row) {
                   var result = 'The id is ' + row["id"] + ' and the name is ' + row["name"];
                   console.log(result);
                        return result;
                    },
                    "targets": 0,
                },      

         ]

Use row["id"] instead of data[0];

edited Oct 16, 2017 at 10:38

answered Oct 16, 2017 at 10:36

juntapao

4273 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

How can I render data from multiple columns into one column?

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related