dynamic column value calculation

mehti

I am pulling data from sql using ajax call. imagine im getting 2 columns back time and distance from DB, i would like to use these values to calculate speed by dividing distance by time. so at the end i'll have three columns two would be from DB and third would be their combination. is it possible to do so?

here is simple call to DB

table = $('#results').DataTable({
"ajax": {
async: false,
global: false,
url: "../php/getResults.php",
dataType: "json"
},
"columns": [{
"data": "Time"
}, {
"data": "Distance"
}, {
"data": "Speed" //needs to be calculate using above two data inputs.
}],
"order": [
[2, 'asc']
]
});

tangerine

Why not do it in your PHP query, so the database returns the calculation?

mehti

Thanks for your reply tangerine. I've simplified the problem as a way to make it a bit easier to understand, unfortunately I can't (or rather don't want to) do it in the PHP query.

mehti

I think I need to use this functionality, however I haven't figured out how yet. I keep getting [object Object]

https://datatables.net/reference/option/rowCallback

when I add the following:

"rowCallback": function (row, data) {
$('td:eq(2)', row).html(data[1] / data[0]);
}

mehti

okay this is how you resolve the problem I had...

createdRow: function (row, data) {
$('td:eq(2)', row).html( data['Distance']/data['Time'] );
}

allan

Use columns.render to perform the calculation.

Allan

mehti

Thanks Alan!