Replies

• allan Posts: 63,389Questions: 1Answers: 10,450 Site admin

  May 2012

  Glad you like the debugger :-).
  
  So the issue here is that you need to tell DataTables what parameter from your JSON you want to assign to each column. At the moment you have "Monitoring status" etc, but DataTables can have no idea that you want that attached to a given column (yes the names match, but that's very unusual :-) ).
  
  The way to do it is to use mDataProp - fully described in this blog post: http://datatables.net/blog/Extended_data_source_options_with_DataTables
  
  Allan
• cdevidal Posts: 6Questions: 0Answers: 0

  May 2012

  OK I read that blog article and didn't think it applied but I'll check again. Is there any reason that following the examples on the website failed? I didn't believe mine deviated from the example all that much.
• cdevidal Posts: 6Questions: 0Answers: 0

  May 2012

  Worked. How do you do it??
• cdevidal Posts: 6Questions: 0Answers: 0

  May 2012

  If the debug data doesn't contain private data, and it looks like it doesn't, I'd like to leave it up for other's sake. Can you comment?
• allan Posts: 63,389Questions: 1Answers: 10,450 Site admin

  May 2012

  The debug includes the data from the table - but nothing else (doesn't include your IP, browser etc) :-).
  
  Good to hear you got it working.
  
  Allan
• jaguayo Posts: 5Questions: 0Answers: 0

  January 2013

  I've got the same problem, including the additional column (which I believe is the cause of the error and lack of returned rows - http://debug.datatables.net/ikusew
  
  I followed the post and links to the use of mDataProp. I've tried reducing input params, using more, alternative values - the works. I'd appreciate a few minutes of your time to look over my usage and tell me where I've gone wrong.
  Thanks in advance-
  
  
  USAGE --
  $(document).ready(function() {
  $('#tbl_vendors').hide();
  var oTable = $('#tbl_vendors').dataTable( {
  "bProcessing": true,
  "bServerSide": true,
  "iDisplayStart": 0,
  "iColumns": 1,
  "sAjaxDataProp": "aaData",
  "sAjaxSource": "fws_json_dt.pl?rc=get_vendors_dt",
  "aoColumns " : [ { "mDataProp": "vname" } ],
  "oLanguage": {
  "sSearch": "Vendor Name: ",
  "sZeroRecords": "No records matched your criteria"
  }
  } );
  
  /* Draw table when contents of search textbox changes */
  $('div.dataTables_filter input').keyup( function () {
  var oSettings = oTable.fnSettings();
  
  if ($('.dataTables_filter input').val().length == 0) {
  oSettings._iDisplayLength = 1;
  $('#tbl_vendors_paginate')[0].style.display = "none";
  }
  else {
  oSettings._iDisplayLength = 10;
  $('#tbl_vendors_paginate')[0].style.display = "block";
  }
  oTable.fnDraw();
  } );
  
  // These objects are hidden by default, allowing query to bring back results before displaying table
  $('#div_vendors').show();
  $('#tbl_vendors').show();
  
  // Set focus on filter textbox
  $('.dataTables_filter input:text').focus();
  }
  
  JSON source --
  
  { "sEcho": 4, "iTotalRecords": 57, "iTotalDisplayRecords": 57, "aaData" : [ {
  "vname":"SMITH, JOHN"
  }
  ] }
• allan Posts: 63,389Questions: 1Answers: 10,450 Site admin

  January 2013

  Thanks for the debug trace. For some reason the mDataProp for your initialisation doesn't look like it is being picked up. Can you link me to a test case showing the issue?
  
  It would also be worth upgrading to the latest release of DataTables.
  
  Allan
• jaguayo Posts: 5Questions: 0Answers: 0

  January 2013

  Thanks, Allan. Unfortunately this is work being done for an intranet, so the URL is blocked. If you agree that mDataProp usage is correct and nothing else looks out of place, I'll upgrade first and see what results that brings.
• jaguayo Posts: 5Questions: 0Answers: 0

  January 2013

  I upgraded to v1.9.4 - same result. I understand it may be difficult to address given that the interface is blocked, but I'm in the process of redeveloping legacy features on the intranet using DataTables. I'll keep playing with it some more - any additional suggestions you have are welcome. Thank you.
• allan Posts: 63,389Questions: 1Answers: 10,450 Site admin

  January 2013

  Can you run your table through the debugger again now that you've updated to 1.9.4 please?
  
  Allan
• jaguayo Posts: 5Questions: 0Answers: 0

  January 2013

  http://debug.datatables.net/equsom
  
  I modified the JSON set to include two rows (wanted to see an odd/even row). The error went away, as did the row data - "0": null. However, table row values for both display the text "undefined", rather than the JSON value.
• jaguayo Posts: 5Questions: 0Answers: 0

  January 2013

  Not to be redundant, but does this reflect what the HTML side should look like? --
  
  
  
  
  Vendor Name
  
  
  
  
  
  
  
  
   
  
  
  
  BTW - we have other forms running datatables, though this is the first to use server-side processing. Users are ecstatic about the product.
• allan Posts: 63,389Questions: 1Answers: 10,450 Site admin

  January 2013

  You are getting undefined because you fnRender method is returning an undefined property of the data source object (there is no index `0` - just a property `vname` ).
  
  fnRender is depreciated in 1.9.4 and I'd strongly recommend you use mRender (and mData rather than mDataProp).
  
  Also, yes your HTML looks fine.
  
  > Users are ecstatic about the product.
  
  Excellent :-)
  
  Allan