How to concat two or more columns of same datatabase table to show in a single datatable column

usha2003

I wanted multiple values form different database columns to show in a single datatable(Editor) column with comma separated values

emil

You can use data from any cell in the same row. You can also use HTML code to format each field.

{
                render: function ( data, type, row ) {
                   return row[0] + " " + RemoveAccents(row[1]) + " " + RemoveAccents(row[2]) + " " + RemoveSpaces(row[3]) + " " + RemoveSpaces(row[4]) + " " + RemoveAccents(row[5]) + " " + RemoveAccents(row[6]) + " k" + row[7] + " " + RemoveSpaces(row[9]);
                },
                targets: 8,
                visible: true,
                searchable: true 
            },

allan

This is correct - use the columns.render option to render data to suit your own needs.

See also the renderers manual page.

Allan

usha2003

Thanks for the help. But I achieved it in a similar manner.
I will show how I solved my case thinking it might help others.
All I wanted was to Concat Different Cols from Database Table to show in Datatable but with single column name hence I used it like this:

"columnDefs": [ {
                                "targets": [12],
                                "data": "purchaseorders.inst1InvoiceNo",
                                "render": function ( data, type, full, meta ) {
                                    var invNo = full.purchaseorders;
                                    var conCat = '';
                                    if(invNo.inst1InvoiceNo)
                                        conCat += invNo.inst1InvoiceNo + ', ';
                                    if(invNo.inst2InvoiceNo)
                                        conCat += invNo.inst2InvoiceNo + ', ';
                                    if(invNo.inst3InvoiceNo)
                                        conCat += invNo.inst3InvoiceNo + ', ';
                                    if(invNo.inst4InvoiceNo)
                                        conCat += invNo.inst4InvoiceNo + ', ';
                                    if(invNo.inst5InvoiceNo)
                                        conCat += invNo.inst5InvoiceNo + ', ';
                                    if(invNo.inst6InvoiceNo)
                                        conCat += invNo.inst6InvoiceNo + ', ';
                                    conCat = conCat.substr(0,conCat.length-2);
                                    return conCat;
                                }
                            } ];

In this case I wanted the values of different columns to be seperated with comma .And I am making use of 'full' argument to get values of all fields fetched from database and combining required fields in specific format.

allan

Thanks for posting back - using columns.render in that way looks like a good option.

Allan