Hi,

I am using the createdRow option to add an attribute to the row. This works fine when I first create the DataTabe. But if I want to change the contents of the table. I have a check to see if DataTables already exists, in this case I clear the table out and then add the new rows.

However when I do this, the variable that I have created "recordset" does not update within the createdRow option. As result, the new rows are added but contain all recordset values.

Please see my code as an example:

                  var recordset = (data.features)
                                  var results = objresults(recordset)

                                      function objresults(recordset) {

                                                                    var columns = []
                                                                    var columnheaders = recordset[0].properties;
                                                                    var len = Object.keys(columnheaders).length;
                                                                    var tablewidth = len * 200;
                                                                    $("#tblResults").width(tablewidth);

                                                                    for (var key in columnheaders) 
                                                                    {
                                                                       var obj = {}
                                                                       var title = "title";
                                                                       var className = "className";
                                                                       var width = "width";
                                                                       obj[title] = key;
                                                                       obj[className] = key; 
                                                                       var vkey = key;
                                                                            var objectlist = TableSettings();

                                                                                for (key in objectlist)
                                                                                {
                                                                                     if ((objectlist[key].hasOwnProperty(vkey)) == true) {
                                                                                        var nestedobject = objectlist[key];
                                                                                        var nestedobject2 = nestedobject[vkey];
                                                                                        var nestedobject3 = nestedobject2["width"];
                                                                                        obj[width] = nestedobject3;
                                                                                    }

                                                                                }

                                                                        columns.push(obj);  
                                                                    }

                                                                    var data = [];

                                                                    for (var i = 0; i < recordset.length; i++) {

                                                                        var rowHash = [] 

                                                                       row = recordset[i].properties;
                                                                        for (var key in row){
                                                                            var value = row[key];

                                                                        rowHash.push(value);
                                                                        }
                                                                        data.push(rowHash);
                                                                    }

                                                                    var objectresult = {columns: columns, data: data};
                                                                    return objectresult
                                                          }

                                                         if (_myTable) {
                                                                                                                                         _myTable.clear();
                                                                                                                                         _myTable.rows.add(results.data)
                                                                                                                                        .draw();
                                                                                                                                        }
                                                                   else
                                        {
                                                   _myTable = $('#tblResults').DataTable(
                                                    {   
                                                             "data": results.data,                                    
                                                             "columns": results.columns,
                                                             "createdRow": function( row, data, dataIndex) {
                                                                 {   
                                                                          var lonlat = recordset[dataIndex].geometry.coordinates;
                                                                           var latlon =  lonlat.reverse();
                                                                           $(row).attr("data.latlong", latlon);
                                                                       }
                                                             },
                                                             "paging":   false,
                                                             "ordering": true,
                                                             "info":     false,
                                                             "searching": false,
                                                             "scrollY": 125,
                                                             "scrollX": 1000

                                                          }              
                                                    );

Would anyone be able to advise where I am going wrong in my code?

Thanks

Dave