Answers

• tangerine Posts: 3,365Questions: 39Answers: 395

  July 2017

  Are you seeing any error message(s)?
• wallin Posts: 4Questions: 1Answers: 0

  July 2017

  No, forgot to specify, we don't have any error message.

  If we force the reload like this

  editor.on('submitSuccess', () => {
          $('#tableId').DataTable().ajax.reload();
  });
  

  we see the new record, but I don't think this should be the normal behaviour.

  Am I wrong?
• rduncecb Posts: 125Questions: 2Answers: 28

  July 2017

  Does the response JSON to the editor ajax call match your Editor setting in regards to dataSrc / root object?
• wallin Posts: 4Questions: 1Answers: 0

  July 2017

  I wasn't, but I fixed it now. Sadly the result is the same, the new record is not showing.

  Here's the setup code of the table

  $(document).ready(function () {
              var editor = new $.fn.dataTable.Editor({
                  ajax: '/PharmaShift/Pharmacy',
                  fields: [
                      {
                          label: 'Address:',
                          name: 'Address'
                      },
                      {
                          label: 'PhoneNumber:',
                          name: 'PhoneNumber'
                      },
                      {
                          label: 'Notes:',
                          name: 'Notes'
                      },
                      {
                          label: 'Shift:',
                          name: 'Shift'
                      }
                  ]
              });
  
              $('#pharmacies').DataTable({
                  ajax: {
                      url: '/PharmaShift/Pharmacies'
                  },
                  dom: 'Bfrtip',
                  columns: [
                      { data: 'Address' },
                      { data: 'PhoneNumber' },
                      { data: 'Notes' },
                      { data: 'Shift' }
                  ],
                  select: true,
                  buttons: [
                      { extend: 'create', editor: editor },
                      { extend: 'edit', editor: editor },
                      { extend: 'remove', editor: editor },
  
                  ]
              });
          });
  

  This is an example of the json source of the datatable (and it works)

  {  
     "data":[  
        {  
           "DT_RowId":"072d349e-e668-47bb-9b8f-de195f20b8d6",
           "Address":"zzz",
           "PhoneNumber":"zzz",
           "Notes":"zzz",
           "Shift":1
        },
        {  
           "DT_RowId":"0e819681-a3ce-45e2-875a-054fcd051f90",
           "Address":"www",
           "PhoneNumber":"www",
           "Notes":"www",
           "Shift":1
        }
     ]
  }
  
  

  This is the json response to the editor create (the record is created on database, but doesn't show up in the datatable)

  {  
     "data":[  
        {  
           "DT_RowId":"63abe340-59cf-4595-ac88-98ba4b443c60",
           "Address":"yyy",
           "PhoneNumber":"yyy",
           "Notes":"yyy",
           "Shift":0
        }
     ]
  }
  
  

  And the datatable debugger result updated:

  https://debug.datatables.net/ilefed

  and no error in console.
• rduncecb Posts: 125Questions: 2Answers: 28

  July 2017 edited July 2017 Answer ✓

  Ah ha, got it. You're missing the table config option on the Editor options. Editor doesn't know what table to work on. See table

  Working example: http://live.datatables.net/cinazabo/3/edit

  Note, I replaced your ajax urls with DT/Editor function versions so i could simulate an ajax call. The important thing is the table (line 4) option on the editor configuration that shows a row will be created. Adding the table option to your code is all you need to do.
• wallin Posts: 4Questions: 1Answers: 0

  July 2017

  That was it, thank you very much for your help and for the very detailed example!