Replies

• allan Posts: 63,400Questions: 1Answers: 10,452 Site admin

  April 2011

  Agreed - showing data when there isn't anything visibly matching can be a bit confusing! I presume that the code you have above is in an fnRowCallback? The advantage of fnRowCallback is that it runs on every row for the displayed rows - the disadvantage is that it's just rendered information, it's not actually in the DataTables data store, and thus not part of the filtering.
  
  So what I would suggest is a little change of plan and to use fnRender instead, which will allow your data to be filtered (you can remove the two source columns from the filter using bSearchable). Now the disadvantage in this case is the fnRender will run only once during the life time of a row (at creation), unless the row is updated. So if you have something which is toggled by the user to select which is being shown, then you'll need to update each row, forcing the render again. If however the decision for what to display is made before the table is initialised and won't change, then fnRender is most certainly the easiest way to go.
  
  Please shout if anything needs clarified - hope this helps!
  
  Regards,
  Allan
• organicspider Posts: 12Questions: 0Answers: 0

  April 2011 edited April 2011

  Thanks allan,
  
  I must be doing something wrong as it still does not work for me :( I have moved the code from fnRowCallback into fnRender[code]"aoColumnDefs": [ { "sClass": "center", "aTargets": [ 0, 1, 2, 3, 4, 5, 6, 7] } ],
  "aoColumns": [
  null,
  { "bSearchable": false },
  { "fnRender": function ( oObj ) { if ( oObj.aData[1] == "0" ) { return oObj.aData[3]; } else { return oObj.aData[4]; } } },
  { "bVisible": false, "bSearchable": false, },
  { "bVisible": false, "bSearchable": false },
  null,
  null,
  null
  ],[/code]Any ideas ?
• allan Posts: 63,400Questions: 1Answers: 10,452 Site admin

  April 2011

  Hmmm - the code looks okay to me, as far as I can tell. At least there is nothing obviously wrong. What part exactly isn't working? Does your third column get the intended data and the filter doesn't work, or is it something else?
  
  Allan
• organicspider Posts: 12Questions: 0Answers: 0

  April 2011

  Hi Allan,
  
  Yep the third column is being populated correctly. An example of what I am seeing is say with the following data:
  
  src dst Number (3rd column)
  --- ---- -------------------------
  01234 789 01234
  02345 456 456
  01234 234 01234
  
  If I enter 789 in the search field it filters the first record; which is confusing to the user as they only see 01234 on the screen.
• allan Posts: 63,400Questions: 1Answers: 10,452 Site admin

  April 2011

  I see. I presume that the order of the src and dst in your above example is not the same as the actual table (otherwise the aoColumns would be slightly incorrect). Can you possibly give me a link to your example? It would be very useful to be able to check that DataTables is adhering to the bSearchable: false (I'd be very surprised if it isn't!). Also you've got a trailing comma in "{ "bVisible": false, "bSearchable": false, }," which IE won't like.
  
  Allan
• organicspider Posts: 12Questions: 0Answers: 0

  April 2011

  Yep, I removed that comma. Let me update my DNS to make the URL available as its internal with sensitive data.