Datatables rowId starting with a number issue

Question

According to the Datatables specs, I can add a unique ID to every row in my table:

$('#myTable').DataTable( {
    ajax: '/api/staff',
    rowId: 'staffId'
} );

However, the same spec says that IDs cannot start with a number. staffIdin my case is a number, I tried to add some prefix to it:

$('#myTable').DataTable( {
    ajax: '/api/staff',
    rowId: 'id_' + 'staffId'
} );

However, this didn't work. Any ideas?

Answer 1

Use function-expression as a value for rowId and return manipulated string to be used as ID

var appListTable = $(".app-list__table").DataTable({
  dom: "",
  // Load json with list of applicants
  ajax: "https://api.myjson.com/bins/391gc",
  columns: [{
    "data": "uid"
  }, {
    "data": "location"
  }, {
    "data": "date"
  }],
  // Set rows IDs
  rowId: function(a) {
    return 'id_' + a.uid;
  },
});

Fiddle here

Answer 2

This is a simple solution, just use

rowId: [1]

This will set the value of first column as row id