Datatables - Merge columns together

Question

I have these database columns, but I want them to be in one column. How would I do that? With mRender, I think?

                    /* Address */  
        {"sTitle": "Address",
                    "bVisible": true,
                    "bSearchable": true},
        /* City */   
        {"sTitle": "City",
                    "bVisible": true,
                    "bSearchable": true},
        /* State */    
        {"sTitle": "State",
                    "bVisible": true,
                    "bSearchable": true},
        /* Zip */    
        {"sTitle": "Zip",
                    "bVisible": true,
                    "bSearchable": true},

Why do you want these to be in 1 column? You can serialize the data but the way you have it now would be easier to search. — CodyEngel, Nov 04 '13 at 21:13
I think it would be easier to understand if all of the address information was location in one column, no? — ChaseC, Nov 04 '13 at 21:14

Jay Rizzi · Accepted Answer · 2015-07-28T12:49:50.957

provided that the columns returned by the datatables get are address, city , state, zip 1-4

if your data returned is a regular array

   { "mData": 0 , //or address field
     "mRender" : function ( data, type, full ) { 
     //data = mData
     //full is the full array address= [0] city = [1] state=[2] zip=[3] 
        return data+', '+full[1]+', '+full[2]+', '+full[3];}
      },

if your data is an associate array

   { "mData": 'address' , 
     "mRender" : function ( data, type, full ) { 
        return data+', '+full['city']+', '+full['state']+', '+full['zip'];}
      },

or you can call mRender independent of mData (though it seems not needed for this situation)

   { "mData": null , 
     "mRender" : function ( data, type, full ) { 
        return full['address']+', '+full['city']+', '+full['state']+', '+full['zip'];}
      },

EDIT: for datatables 1.10, just change the names a bit, drop the "m"

   { "data": null , 
     "render" : function ( data, type, full ) { 
        return full['address']+', '+full['city']+', '+full['state']+', '+full['zip'];}
      },

*note i'm not taking into account whether you should store this data in one column, just showing how its done

score 4 · Answer 2 · edited Jan 02 '19 at 08:36

4

database table fields : id,first_name,last_name,email

datatable : full_name,email (without id) ?

"columns": [
            {
             "mData": null ,
             "mRender" : function ( data, type, full ) {
                return full['first_name']+' '+full['last_name'];
              }
             },

edited Jan 02 '19 at 08:36

Saifur Rahman

144
2
14

answered May 12 '17 at 07:55

Bekir Bozkurt

94
8

2

Please [edit] this answer to improve the formatting. – Baum mit Augen May 12 '17 at 12:21

score 0 · Answer 3 · answered Sep 17 '18 at 10:23

$(document).ready(function() {
    $('#example').DataTable( {
        "columnDefs": [
            {
                // The `data` parameter refers to the data for the cell (defined by the
                // `data` option, which defaults to the column being worked with, in
                // this case `data: 0`.
                "render": function ( data, type, row ) {
                    return data +' ('+ row[3]+')';
                },
                "targets": 0
            },
            { "visible": false,  "targets": [ 3 ] }
        ]
    } );
} );

Datatables - Merge columns together

3 Answers3

Linked