if inside column definition?

redsunset

Hi!
I would like to add a dynamic column to my table based on a variable that has different values.

I am using:

var sroles = ... different int value ... ; 

  // On page load: datatable
  var table_cards = $('#table_cards').DataTable({
    "ajax": "data-search.php,
    "columns": [
      { "data": "data1" }, 
      { "data": "data2" },
      { "data": "data3" },
      { "data": "data4",   "sClass": "cardname" },
      { "data": "data5" },
      { "data": "data6"},
      { "data": "data7", "sClass": "integer2"},
      { "data": "data8", "sClass": "integer"},
      { "data": "data9", "sClass": "integer"},
      { "data": "data10"},
      { "data": "data11"},
    if(sroles == 1) { THAN ADD  { "data": "data12" } }

    ],

is that possible? thank you in advance!

kthorngren

Doing something like that is not proper Javascript syntax. You can create a Javascript variable containing the base columns array. Then use the Javascript push() method to push the additional column if required. For example:

var columns = [
      { "data": "data1" },
      { "data": "data2" },
      { "data": "data3" },
      { "data": "data4",   "sClass": "cardname" },
      { "data": "data5" },
      { "data": "data6"},
      { "data": "data7", "sClass": "integer2"},
      { "data": "data8", "sClass": "integer"},
      { "data": "data9", "sClass": "integer"},
      { "data": "data10"},
      { "data": "data11"}
];

if(sroles == 1) {
    columns.push( { "data": "data12" } );
}

  var table_cards = $('#table_cards').DataTable({
    "ajax": "data-search.php,
    "columns": columns
});

Kevin

redsunset

great! thank you very much!