Adding text to json data in Datatables

Question

I'm trying to add text to my data before creating a table with jQuery DataTables.

For example, my JSON data is [1,5,6,12] and I want to present it as [1 seconds, 5 seconds, 6 seconds, 12 seconds].

JavaScript:

$(document).ready(function () {
    $('#utilisation').DataTable({
        dom: 'Bfrtip',
        buttons: [
            'print'
        ],           
        'ajax': {
            "type": "POST",
            "url": '../Servlet?',
            "dataSrc": ""
        },
        'columns': [
            {"data": "router"},
            {"data": "local"},
            {"data": "startdate"},
            {"data": "enddate"},
            {"data": "duration"}
        ]
    } );       
});

You need access to the data before you apply it to #utilisation. Maybe this can be done in a callback when DataTable gets the data. Inside this callback before it is sent to the target you can manipulate the strings. — tmthydvnprt
– tmthydvnprt, Commented Mar 16, 2016 at 12:22

Gyrocode.com · Accepted Answer · 2016-03-16 14:47:13Z

3

Use columns.render option to render the data for use in the table.

'columns': [
    {"data": "router"},
    {"data": "local"},
    {"data": "startdate"},
    {"data": "enddate"},
    {
       "data": "duration",
       "render": function(data, type, row, meta){
          if(type === 'display'){
             data = data + ((data == 1) ? " second" : " seconds");
          }
          return data;
       }
    }
]

edited Mar 16, 2016 at 14:47

answered Mar 16, 2016 at 13:47

Gyrocode.com

59k16 gold badges157 silver badges192 bronze badges

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

Collectives™ on Stack Overflow

Adding text to json data in Datatables

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related