Answers

• allan Posts: 63,498Questions: 1Answers: 10,470 Site admin

  September 14

  Here is a basic Editor example.

  Editor will submit all fields which have changed value, so there is something that has changed between the original data for the row and the data that is read from the form. The information above isn't complete (I don't see the read in data, or the fields for Editor), but the two most common reasons for this are:

  • null data in the original data source. HTML input elements can't hold a null value, they must be strings, and since null !== '' that can result in what you are seeing.
  • When using select if a value is not in the list of options, the top option from the options will be used, thus will be different from the original data.

  Do either of them track?

  Allan
• minifiredragon Posts: 82Questions: 16Answers: 2

  September 14

  Neither of them track. I am only using a text field. And as I had said, the data entered is sent (even if the field is "blank" aka, the data erased from the field. But occasionally a few other fields are sent at the same time (which cannot be from the user, since once you press enter, it is sent and there is no way to get to another field).

  Here is what is going on with the table always checking with for updated information:

  var table = $j('#example').DataTable();
      //this adds new rows if there are any to add
          for(var i=0; i<d.data.length; i++)
          {
              let rw = table.row((idx, data) => data.sku === d.data[i].sku);
              if( rw.data() )
              {
                 var rd = table.row('#'+rw.data().DT_RowId).data();
                 $j.extend(rd,d.data[i]);
                 table.row('#'+rw.data().DT_RowId).data(rd).invalidate();
  
                 var node = table.row('#'+rw.data().DT_RowId).node();
                  $j(node).effect( "highlight", {color:"#99ff99"}, 3000 );
              }
              else
              {
                  table.row.add(d.data[i]).draw(false);
              }
          }
  //this adds in the new data if there is any.
          for(var i=0; i<d.liveData.length; i++)
          {
              let rw = table.row((idx, data) => data.sku === d.liveData[i].sku);
              if( rw.data() )
              {
                  var rd = table.row('#'+rw.data().DT_RowId).data();
                  $j.extend(rd,d.liveData[i])
                  table.row('#'+rw.data().DT_RowId).data(rd).invalidate();
              }
              else
              {
                  //if it is not found, don't add blank data;
                  //table.row.add(d.liveData[i]).draw(false);
              }
          }
  

  If the person is editing the table when an update occurs, it kicks them out of the edit and they have to start the edit again, so there technically should be no changed data when the edit begins.
• minifiredragon Posts: 82Questions: 16Answers: 2

  September 14 edited September 14

  Forgot this:

  (I don't see the read in data, or the fields for Editor)

  I left out the below part because it was standard for getting the fields to work, and nothing special was in it. The table is generated by an array of structs of available columns. The language is coldfusion, it checks if the field is an editable field, and if it is, let it be editable.

  table: '#example',
                      fields: [
                          <cfloop from="1" to="#ArrayLen(tColAr)#" index="j">
                              <cfloop from="1" to="#ArrayLen(dt.tableColumns)#" index="k">
                                  <cfif tColAr[j] EQ dt.tableColumns[k].colDataName>
                                      <cfif dt.tableColumns[k].editable NEQ 0 AND dt.tableColumns[k].dataLocation NEQ 'settings' >
                                          { label: '#dt.tableColumns[k].colTableName#:', name: '#dt.tableColumns[k].colDataName#' },
                                      </cfif>
                                  </cfif>
                              </cfloop>
                          </cfloop>
                      ]
  
• allan Posts: 63,498Questions: 1Answers: 10,470 Site admin

  September 14

  Could you try adding this to your code:

    editor.on('preSubmit', function (e, data, action) {
      let rowData = table.row( editor.ids(true) ).data();
      
      console.log('Original rowData: ' + JSON.stringify(rowData));
      console.log('Modified data: ' + JSON.stringify(data));
    });
  

  Live example.

  And then give the the output when the error happens? It will dump the original data, and also the modified data that gets submitted.

  Thanks,
  Allan
• minifiredragon Posts: 82Questions: 16Answers: 2

  September 18

  Sorry it has taken so long. The problem is random and I have not got it to occur again yet. I will keep an eye out for it to occur and post the data. I also have updated the datatables since I have had the issue. I do not know which version I was using, but it was 2.0, but not 2.1.

  When I have someone really working away on the table I will remove the safety check. At that point it gives an error on the editor when it occurs and they can notify me when that happens, and I can grab the information we are looking for.
• allan Posts: 63,498Questions: 1Answers: 10,470 Site admin

  September 19

  No worries - let me know if you find anything.

  Allan