render datatables columns fetched via ajax

Question

I'm using datatables via ajax and display the table like this

var table = $('#data').DataTable( {
        "ajax": "initTable.php",
        "columns": [
            { "data": "orderid" },
            { "data": "first_name"},
            { "data": "last_name"},
            { "data": "unix" },
            { "data": "final_total" }
        ]
    } );

I've tried

{ "data": "first_name" + "data": "last_name"},

But I get an error and table is not displayed. So how can I change the render to display first name next to last_name in the same cell not in the next cell

[UPDATE]

Tried

"ajax": "initTable.php",
"columns": [
            { "data": "orderid" },
            { "data": "first_name"},
            {"data": "last_name"},
            { "data": "unix" },
            { "data": "final_total" }
        ],
        "columnDefs": [
            {
                "render": function ( data, type, row ) {
                    return data + row[2];
                },
                "targets": 1
            },
            { "visible": false,  "targets": [ 2 ] }
        ]

(Note: I have to define column rows because I get many columns (about 20) and want to display just 4 or 5) But I get the first name followed by 'undefined' something like "Andy undefined"

Take a look to column rendering

gaetanoM
– gaetanoM

2016-10-16 21:29:44 +00:00
Commented Oct 16, 2016 at 21:29 — gaetanoM
– gaetanoM, Commented Oct 16, 2016 at 21:29
updated please review. I get the last name 'defined'

PHP User
– PHP User

2016-10-16 21:41:18 +00:00
Commented Oct 16, 2016 at 21:41 — PHP User
– PHP User, Commented Oct 16, 2016 at 21:41

Gyrocode.com · Accepted Answer · 2016-10-17 00:50:44Z

2

Use the code below:

{
    "render": function ( data, type, row ){
        return row["first_name"] + " " + row["last_name"];
    },
    "targets": 1
},

Also there is no need to include last_name column if you're hiding it.

answered Oct 17, 2016 at 0:50

Gyrocode.com

59k16 gold badges157 silver badges192 bronze badges

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

2 Comments

PHP User Over a year ago

Great thanks a lot. And used: { "visible": false, "targets": [ 2 ] } to hide the last name field.

Gyrocode.com Over a year ago

@PHPUser, as I said you don't have to include last_name field in the table and can remove {"data": "last_name"} and ` { "visible": false, "targets": [ 2 ] }` as long as last_name is available in the Ajax response.

Collectives™ on Stack Overflow

render datatables columns fetched via ajax

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related