Answers

• kthorngren Posts: 21,343Questions: 26Answers: 4,954

  March 2020

  One option is to use cells().every() to iterate all the cells of a particular column then use cell().data() to update the cell. For example:
  http://live.datatables.net/picabidi/1/edit

  Kevin
• YoDavish Posts: 123Questions: 46Answers: 3

  March 2020 edited March 2020

  @kthorngren so it shows in the datatables as updated for my column, however, when I look at the actual database table it's not actually saving to it. When I refresh the page, the columns are set to no. If I manually, select the cell to yes it updates into the database table correctly. Here is the entire code below:

  //GLOBAL VARS
  var tab;
  var editor;
  
  //Ready function
  $(document).ready(function() {
      setupDataTables();
      setupDTSearches();
  })
  
  function setupDataTables() {
      editor = new $.fn.dataTable.Editor( {
          table: '#table',
          ajax: "tableServer-returnMail.php",
          fields: [
              {
                  label: "AssignedTo",
                  name: "AssignedTo",
                  type:  "autoComplete",
                  opts: {
                      source: "autoComplete-returnMail.php"
                  }
              },
              {
                  label: "Note",
                  name: "Note",
              },
              {
                  label: "Completed",
                  name: "Completed",
                  type: "select",
                  options: [
                      { label: "No",      value: 0},
                      { label: "Yes",     value: 1}
                  ]
              }
          ]
      } );
  
      tab = $("#table").DataTable({
          ajax: "tableServer-returnMail.php",
          dom: "Bfrtip",
          columns: [
              { data: "AssignedTo" },
              { data: "Note" },
              { data: "Completed" },
              { data: "originalFileDate" },
              { data: "currentFileName" },
              { data: "currentFilePath" },
              { data: "user" },
              { data: "barcode" },
              { data: "companyName" }
          ],
          autoFill: {
              columns: ':nth-child(2),:nth-child(3),:first-child',
              editor:  editor
          },
          keys: {
              columns: ':nth-child(2),:nth-child(3),:first-child',
              editor:  editor
          },
          select: {
              style:    'os',
              selector: 'td:first-child',
              blurable: true
          },
          buttons: [
              'copy', 'csv', 'excel'
          ],
          "initComplete": function () {
              tab.order([3,"desc"]);
              tab.draw();
          },
          "pageLength": 100
      });
  
          $("#completed").on('click', function () {
              ConfirmDialog('Mark all rows as completed?', tab);
        })
  }
  
  function ConfirmDialog(message, tab) {
      $('<div></div>').appendTo('body')
      .html('<div><h6>' + message + '?</h6></div>')
      .dialog({
          modal: true,
          title: 'Confirmation',
          zIndex: 10000,
          autoOpen: true,
          width: 'auto',
          resizable: false,
          buttons: {
          Yes: function() {
              tab.cells(null, 2).every( function () {
              this.data("1");
              });
              tab.draw();
          $(this).dialog("close");
          },
          No: function() {
              $(this).dialog("close");
          }
      },
      close: function(event, ui) {
          $(this).remove();
      }
      });
  };
  
• colin Posts: 15,240Questions: 1Answers: 2,599

  March 2020 edited March 2020

  Kevin's answer is correct, if you're not using Editor - you forgot to mention that bit!

  With Editor, you would need to use edit() to modify each row, or use multiSet() to edit them all in a single operation (though not sure how it would cope if too many were set).

  Colin
• kthorngren Posts: 21,343Questions: 26Answers: 4,954

  March 2020

  You didn't mention you were using Editor and that you wanted the Database to be updated. You can use the edit() API. Check the docs for using the row selector and examples,.

  Kevin