Answers

• rf1234 Posts: 2,991Questions: 87Answers: 421

  January 2018 Answer ✓

  Interesting. I couldn't make it work either. But here is a solution replacing "className" in "columns" with "render". That works!

  $(document).ready( function () {
    var dataReturnedByCustomAjax=
      "data":[{...}]",
      "columns":[
        {"data":"Name","title":"Emp Name","className":"column_Name"},
        {"data":"Age", "title":"Age", "render":function(data,type,row,meta){return Number(data).toFixed(2);}},
      ],
    };
    // This table has no columns in HTML.  They are created by Datatables
    var table = $('#example1').DataTable({
      "deferRender": true,
      "data":dataReturnedByCustomAjax.data,
      "columns":dataReturnedByCustomAjax.columns,
      "columnDefs":[
        // This works, referencing column by number:
         //{"targets":1,"render":function(data,type,row,meta){return Number(data).toFixed(2);}},
      ]
    });
  
    // This table has columns in HTML.  They are not created by Datatables
    var table2 = $('#example2').DataTable({
      "data":dataReturnedByCustomAjax.data,
      "columns":dataReturnedByCustomAjax.columns,
      "columnDefs":[
        // When the columns are defined in HTML, this works with no problem
        {"targets":"column_Age","render":function(data,type,row,meta){return Number(data).toFixed(2);}},
      ]
    });
  });
  
• allan Posts: 63,498Questions: 1Answers: 10,471 Site admin

  January 2018

  The problem here is that the columnDefs are actually applied before the columns (allowing the more specific columns to override anything set by the columnDefs).

  This is a limitation of the columnDefs.targets, no question. I haven't yet worked out a nice way of resolving it I'm afraid.

  Allan
• nikhilsheth2049 Posts: 17Questions: 4Answers: 0

  May 2018

  Any updates about columnDef.targets should be column title instead of column index?
• allan Posts: 63,498Questions: 1Answers: 10,471 Site admin

  May 2018

  No - this isn't likely to come until v2 I'm afraid.

  Allan