Answers

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

  October 2017

  What are you using to display the editing view?
• skazi Posts: 7Questions: 3Answers: 0

  October 2017

  Hi Allan I am using Jquery datatables for the editting view.
• skazi Posts: 7Questions: 3Answers: 0

  October 2017

  Please find the code below:

  $(document).ready(function() {
  editor = new $.fn.dataTable.Editor( {
  table: "#myTable",
  idSrc: 'intakeid',
  fields: [ {
  label: "Intake ID:",
  name: "intakeid"
  }, {
  label: "Status:",
  name: "status"
  }, {
  label: "Requester:",
  name: "requester"
  }, {
  label: "Create date:",
  name: "createdate"
  }, {
  label: "Target date:",
  name: "targetdate"
  }, {
  label: "Intake Type:",
  name: "intaketype"
  }, {
  label: "Request Team",
  name: "requestteam"
  }, {
  label: "Notify Email",
  name: "notifyemail"
  }, {
  label: "Comments",
  name: "comments"
  }
  ]
  } );

  var table = $('#myTable').DataTable( {
      dom: "Bfrtip",
      "iDisplayLength": 15,
      "lengthChange": false,
      "ordering": false,
      "info":     false,
      'columnDefs': [
       {
          'targets': 1,
          'orderable': false,
          'checkboxes': {
             'selectRow': true
          }
       }
        ],
        'select': {
           'style': 'multi'
        },
  
      columns: [
          { data: null, render: function ( data, type, row ) {
              // Combine the first and last names into a single table field
              return '';
          } },
          { data: "intakeid" },
          { data: "status" },
          { data: "requester" },
          { data: "createdate" },
          { data: "targetdate" },
          { data: "intaketype" },
          { data: "requesteam" },
          { data: "email" },
          { data: "comments", render: $.fn.dataTable.render.number( ',', '.', 0, '$' ) }
      ],
      select: true,
      buttons: [
          'selectAll',
          'selectNone',
  
          { extend: "create", editor: editor },
          { extend: "edit",   editor: editor },
          {
              extend: "selectedSingle",
              action: function ( e, dt, node, config ) {
                  // Immediately add `250` to the value of the salary and submit
                  editor
                      .edit( table.row( { selected: true } ).index(), false )
                      .submit();
              }
          },
          { extend: "remove", editor: editor }
      ]
  });
  
  $('#min,#max').datepicker({
      format: "mm/dd/yyyy",
      weekStart: 1,
      daysOfWeekHighlighted: "0",
      autoclose: true,
      todayHighlight: true
  });
  
  // Add event listeners to the two range filtering inputs
  $('#min,#max').change(function(){ table.draw(); });
  

  });
• allan Posts: 63,498Questions: 1Answers: 10,471 Site admin

  October 2017

  You need to add the ajax option to the Editor configuration to tell it where to send the data. An example of that is available here.

  The manual details the client / server parameters that Editor uses.

  Regards,
  Allan
• skazi Posts: 7Questions: 3Answers: 0

  October 2017

  Hi Allan,
  Does the editor license needs to be renewed every time or it's a one time purchase? Also, is it possible to extend the trial time? I am still trying to get it to work..
• allan Posts: 63,498Questions: 1Answers: 10,471 Site admin

  October 2017

  One time purchase. All v1.x releases of the software are included in the license.

  And yes, absolutely no problem to extend the trial - I've just done that for your account and a fresh trial can be downloaded from the following address when logged in with your account.

  Only the dataTables.editor.js and dataTables.editor.min.js files need to be updated in your current install from the updated trial package. You may need to clear your browser's cache to make sure the updated files are picked up.

  Regards,
  Allan