Replies

• allan Posts: 61,972Questions: 1Answers: 10,160 Site admin

  March 2013

  > Does anyone know why the _START_ value is not being set to the correct value?
  
  Nope no idea. Can you give us a link to a test case please?
  
  Allan
• sbirnie Posts: 11Questions: 1Answers: 0

  March 2013 edited March 2013

  I wish I could. It's an intranet only application.
• sbirnie Posts: 11Questions: 1Answers: 0

  March 2013

  This thing is a big bear.
  
  [code]
  oTable = $("#searchResultsTable").dataTable({
  "bDestroy": true
  ,"sDom": "tpi"
  ,"bFilter": false
  ,"bLengthChange": false
  ,"iDisplayLength": iDisplayLength
  ,"iDisplayStart": iDisplayStart
  ,"aaSorting": aaSorting
  ,"bProcessing": false
  ,"sScrollY": "200px"
  ,"bScrollCollapse": true
  ,"bInfo": true
  ,"bStateSave": false
  ,"oLanguage": {
  "sInfo" : "Displaying _START_ to _END_ of _TOTAL_ results"
  }
  ,"sPaginationType": "two_button"
  ,"bServerSide": true
  ,"sAjaxSource": ""
  ,"iDeferLoading": iLastQueryCount
  ,"bDeferRender": true
  ,"sAjaxDataProp": "mngSearchResults"
  ,"aoColumnDefs" : [
  {"mDataProp":"field1","bSortable":false, "aTargets":[0]}
  ,{"mDataProp":"field2", "aTargets":[1]}
  ,{"mDataProp":"field3", "aTargets":[2]}
  ,{"mDataProp":"field4", "aTargets":[3]}
  ,{"mDataProp":"field5", "aTargets":[4]}
  ,{"mDataProp":"field6", "aTargets":[5]}
  ,{"mDataProp":"field7", "aTargets":[6]}
  ,{"mDataProp":"field8", "aTargets":[7]}
  ,{"mDataProp":null, "bSortable":false, "aTargets":[8]}
  ]
  ,"fnServerData": function(sSource, aoData, fnCallback) {
  // Block the table with a light gray overlay so the user can't do multiple clicks
  $('#searchResultsTable_wrapper').block({
  message:null,
  overlayCSS:{backgroundColor: '#000',opacity:0.2}
  });
  // Set initial process type to send to the server.
  $("#processType").val(processType);
  // Clear the selectedRows string since they can't do cross-page edits.
  $('#selectedRows').val('');
  // Post the form data to the server so it will pick up the search parameters
  var formData = $("#SrcForm").serializeArray();
  $.each(formData, function(i, field) {
  aoData.push({"name":field.name, "value":field.value});
  });
  
  // Do the actual ajax post to the server
  $.ajax({
  "dataType": "json",
  "type": "POST",
  "url": sSource,
  "data": aoData,
  "success": function(data, textStatus, jqXHR) {
  $('#searchResultsTable_wrapper').unblock();
  setButtonsEnabled(true);
  // Process any server-side error messages here.
  if (!processServerMessages(data) && data.mngSearchResults != null && data.mngSearchResults.length > 0) {
  $("#lastQueryCount").val(data.lastQueryCount);
  $('#searchResults').show();
  isAjaxData = true;
  hiddenSearchResultElements = '';
  fnCallback(data, textStatus, jqXHR);
  $('#hiddenSearchResultElements').html(hiddenSearchResultElements); // Add all the hidden form search results fields back into the DOM Form
  $('#searchResultsTable_wrapper .dataTables_scrollBody').scrollTop(0); // scoll up to top on each Prev/Next page
  }
  },
  "error": function(xhr, textStatus, thrownError) {
  $('#searchResultsTable_wrapper').unblock();
  setButtonsEnabled(true);
  handleAjaxError(xhr, textStatus, thrownError);
  }
  });
  }
  ,"fnRowCallback": function(nRow, aData, iDisplayIndex, iDisplayIndexFull) {
  // Do any post-processing of server data here before each row is added to the table
  if (isAjaxData) {
  // doing stuff that would take forever to scrub, so I just deleted
  
  // Create a checkbox to update the selected id list
  $('td:eq(0)', nRow).html('');
  
  // Setup the image link to run the associated SC search
  var imgSrc = "";
  $('td:last', nRow).html('');
  //$('td:last', nRow).html('');
  }
  
  // Replace any empty cells with a nbsp so IE will show the cell border
  $('td:empty', nRow).html(' ');
  // Draw the right border since IE doesn't show it when there's no scrollbar
  $('td:last', nRow).css("border-right", "1px solid #aaaaaa");
  return nRow;
  }
  ,"fnInitComplete": function() {
  $('#searchResults').show();
  //oTable.fnAdjustColumnSizing(false);
  // For some reason, the oTable variable is still null at this point, which conflicts with the DataTables documentation.
  // So have to reference the table by getting it from the DOM id.
  $('#searchResultsTable').dataTable({"bRetrieve": true}).fnAdjustColumnSizing(false);
  
  if (scrollTop > 0) {
  $("#searchResultsTable_wrapper .dataTables_scrollBody").scrollTop(scrollTop);
  scrollTop = 0; // prevent this from happening more than once
  }
  
  // Make sure processType doesn't remain stuck on 'INIT' mode for each pagination ajax call
  processType = 'SEARCH';
  
  // Keep them from doing any type of server-side Ajax pagination or sorting when editing data.
  
  disableDataTablePagination('searchResultsTable');
  
  }
  });
  [/code]
• sbirnie Posts: 11Questions: 1Answers: 0

  March 2013

  When is the _START_ field populated, and with what variable? Is there something I can look for with firebug? Is this being set by a variable from the server or is it possibly cached in the browser?
• allan Posts: 61,972Questions: 1Answers: 10,160 Site admin

  March 2013

  > When is the _START_ field populated, and with what variable?
  
  It is an internally calculated value which is why we'd need a test case to see what is happening. Since you can't provide us with one, you'll likely need to add some debug statements to DataTables core to see what is happening.
  
  Allan