Answers

• p3loads Posts: 11Questions: 3Answers: 0

  October 2019 edited October 2019

  Jquery code ('...url' is fictitious):

  `
  var tableId = '#pagesTable';

      var editor = new $.fn.dataTable.Editor({
          ajax: '...url',
          table: tableId,
          idSrc: 'pageid',
          fields: [
              { label: 'Order:', name: 'ordering', fieldInfo: 'This field can only be edited via click and drag row reordering.' },
              { label: 'Title:', name: 'title' },
          ]
      });
  
  
      var table = $(tableId).DataTable({
          ajax: '...url',
          columns: [
              { data: 'ordering' },
              { data: 'title' },
          ],
          rowReorder: {
              dataSrc: 'ordering',
              editor:  editor
          },
  
      });
  

  `
• p3loads Posts: 11Questions: 3Answers: 0

  October 2019 edited October 2019

  I have also added some event listeners to "debug" the code:

          table.on( 'row-reordered', function ( e, diff, edit ) {
              console.log("reorder");
          });
  
          editor
              .on('postCreate postRemove', function () {
                  console.log("postCreate");
              })
              .on('initCreate', function () {
                  console.log("initCreate");
              })
              .on('initEdit', function () {
                  console.log("initEdit");
              })
              .on('preSubmit', function () {
                  console.log("preSubmit");
              });
  

  Without an editor in rowReorder options, the 'row-reordered' event is fired by table.

  However, if I set editor (as code in my previous post) only 'initEdit' events get fired.

  Thanks
• colin Posts: 15,179Questions: 1Answers: 2,590

  October 2019 Answer ✓

  Hi @p3loads ,

  It's working as expected in this example, so it's going to be something to do with your implementation. Are you able to link to your page, or create a test case if that's not possible.

  Cheers,

  Colin
• p3loads Posts: 11Questions: 3Answers: 0

  October 2019

  Hi @colin
  thanks four your feedback. I have packaged a static html file that you can access here:
  https://u25e.z16.web.core.windows.net
  The example gets few data at startup from a static json file '/json/pages.json'.
  On JS console you can verify that only 'initEdit' event is triggered after reordering through d-n-d.
  I have attempted to figure out but withou success so far.

  Thanks for your feedbacks.
  Regards
• p3loads Posts: 11Questions: 3Answers: 0

  October 2019

  Hi @colin, did you give a look into it?
  Best
• allan Posts: 61,972Questions: 1Answers: 10,160 Site admin

  October 2019 Answer ✓

  Hi,

  I'm going to take over from Colin here - thanks for the example. Could you add rowId: 'pageid' to your DataTable initialisation object please?

  Thanks,
  Allan
• p3loads Posts: 11Questions: 3Answers: 0

  October 2019

  Hi @allan ,

  yes now it works! Now correctly fires a 'preSubmit' event right before posting to server. Sorry, but I was unable to figure out.
  Thanks a lot for your valuable support.
  Best to All