Answers

• allan Posts: 63,327Questions: 1Answers: 10,436 Site admin

  January 2019

  Hi,

  I don't immediately see anything wrong there. Could you show me your DataTables initialisation and also take a trace with the debugger please - click the Upload button and then let me know what the debug code is.

  Thanks,
  Allan
• abarnes Posts: 16Questions: 5Answers: 0

  January 2019

  With this particular one I am using my own ajax script. I initialize with this and call a function. It works perfect except for the options on select. I can edit fields etc.

  $.ajax( {
          url: deviceTBL+'&request=system',
          dataType: 'json',
          success: function ( json ) {
              for ( var i=0, ien=json.data.length ; i<ien ; i++ ) {
                  loadData( json.data[i] );
              }
          }
      } );
  
• abarnes Posts: 16Questions: 5Answers: 0

  January 2019

  Another thing I find strange through debugging is if the Location field is set as type "select", everytime I update a field it sends the field location to be updated as well. For example if I update Asset, the data submits to change Asset and Location. If I declare the field as a regular field this doesn't happen.
• abarnes Posts: 16Questions: 5Answers: 0

  January 2019

  For clarification what I'm trying to accomplish is user clicks a regular field to edit and editor provides a dropdown of choices. I don't want the dropdown in the regular table.
• abarnes Posts: 16Questions: 5Answers: 0

  January 2019

  I'm also using the standalone option as I'm updating labels instead of tables
• abarnes Posts: 16Questions: 5Answers: 0

  January 2019

  UPDATE:

  Here is what I finally got to work. Is this the proper way to load select options for 2 fields?

  $.ajax( {
          url: deviceTBL+'&request=system',
          dataType: 'json',
          success: function ( json ) {
              for ( var i=0, ien=json.data.length ; i<ien ; i++ ) {
                  loadData( json.data[i] );
              }
              var optionsLocation = [];
              var optionLocation = {};
              $.each(json.options.deviceLocation, function (i, e) {
                  optionLocation.label = e.label;
                  optionLocation.value = e.value;
                  optionsLocation.push(optionLocation);
                  optionLocation = {};
              });
              editor.field('deviceLocation').update(optionsLocation);             
              var optionsDept = [];
              var optionDept = {};
              $.each(json.options.deviceDept, function (i, e) {
                  optionDept.label = e.label;
                  optionDept.value = e.value;
                  optionsDept.push(optionDept);
                  optionDept = {};
              }); 
              editor.field('deviceDept').update(optionsDept);         
          }
      } );
  
• abarnes Posts: 16Questions: 5Answers: 0

  January 2019

  Last Update: This is the final code. Is this the best way? Works perfect.

  function refreshSystem(){
          $.ajax( {
              url: deviceTBL+'&request=system',
              dataType: 'json',
              success: function ( json ) {
                  for ( var i=0, ien=json.data.length ; i<ien ; i++ ) {
                      loadData( json.data[i] );
                  }
                  var optionsLoad = [];
                  var optionLoad = {};
                  $.each(json.options, function (i, e) {
                      console.log(i);
                      if(json.options[i] != null){
                          $.each(json.options[i], function (j, e) {
                              optionLoad.label = e.label;
                              optionLoad.value = e.value;
                              optionsLoad.push(optionLoad);
                              optionLoad = {};
                          });
                          editor.field(i).update(optionsLoad);
                          optionsLoad = [];
                      }
                  });
              }
          } );
      }
  
• allan Posts: 63,327Questions: 1Answers: 10,436 Site admin

  January 2019

  With this particular one I am using my own ajax script. I initialize with this and call a function. It works perfect except for the options on select. I can edit fields etc.

  That would do it. If you aren't using DataTables' own ajax option then Editor can't auto detect the options. So yes, the field().update() method is the correct way of doing this.

  Allan