Replies

• fbas Posts: 1,094Questions: 4Answers: 0

  October 2011

  1. yes
  
  2. no can't use DataTables without THEAD, but you can hide it if you want
  
  3. yes. you can programatically sort (see http://www.datatables.net/ref#fnSort ) so you could use any control you want that responds to whichever event you want by triggering fnSort.
• kunal Posts: 16Questions: 0Answers: 0

  October 2011 edited October 2011

  @fbas - Thanks for answering my query. I will check out the link that you have posted. I will ask my questions in the same post.
  
  Can you give me any example of hiding the thead. I think I can use jQuery.hide() for doing that, but I need to look into it. More suggestions are welcome.
• fbas Posts: 1,094Questions: 4Answers: 0

  October 2011

  yes, I'd suggest using jQuery.hide().
  
  if you're using sScrollX/sScrollY be aware that the header is copied out and put into a separate header, so you'll want to .hide() that as well.
• kunal Posts: 16Questions: 0Answers: 0

  October 2011 edited October 2011

  Hi,
  
  I have put the thead tags and tried to initialize table under $(document).ready() using the code below. I am not using dataTables to create the table and populate it dynamically, it is done using ajax call in success of another ajax call.
  
  So I am creating a table first which is getting displayed in html and then applying datatables to it. But the table is not getting displayed with the options below. In fact datatable is not getting applied to it.
  
  Please suggest whats going wrong here.
  
  [code] var oTable = $('#table_id').dataTable({
  
  "bDestroy":true,
  "aaSorting": [[2,'asc'], [3,'asc']],
  "sPaginationType": "full_numbers",
  "bLengthChange": false,
  "bFilter": false,
  "bSort": true,
  "bInfo": false
  
  });
  [/code]
  
  Edit: With the above call still present in my code and not able to apply dataTable to it. I just tried using javascript console in chrome and ran the same above code and it seems to work fine like that. It was showing the table formatted with the pagination, sorting and search feature. I am wordering how to initialize it in my html file.
• GregP Posts: 500Questions: 10Answers: 0

  October 2011

  Why bDestroy: true? I've never used that parameter, but my understanding of it is that if the selector matches (I'm assuming you have a #table_id) it will be destroyed and replaced with a new table matching the initializer. Only, you do not have an AJAX data source, so there's no new table to be constructed. I think you're just destroying it. ;-)
  
  I could be going wacky, though. This has been known to happen.
• kunal Posts: 16Questions: 0Answers: 0

  October 2011 edited October 2011

  Hi Greg,
  
  Thanks for the reply. I have used bDestroy: true only while running it from the console on chrome as it datatables was giving some error, but I will try it without that also. In my actual development code I have not used bDestroy: true. I am calling [code] oTable = $('#table_id').dataTable(); [/code] after finishing all the ajax calls and building the table to initialize datatables. In this case, dataTables is not getting applied.
  
  I have tried putting the above code in the success call of first ajax call within which the table is getting constructed dynamically using getJSON call. Here I can see the dataTables being applied but it shows only the 1st 10 records of the table that is being formed dynamically.
  
  Please suggest if you have come across this problem before.
  
  Thanks,
  Kunal
• kunal Posts: 16Questions: 0Answers: 0

  October 2011

  Update: Since I am making a table dynamically, I have put the datatable initialization call after ajax calls get executed. Even then the datatable is not getting applied. My guess is since the table at the time of the call is not created in DOM so the initialization is failing.
  
  So I made a call using setTimeOut() function with 500ms timer, and I found that the datatable is applied. But instead of showing 10 rows in default mode [code] $('#table_id').dataTable();[/code], it is only showing 9 rows.
  
  Again, I would like to ask:
  
  1. If applying datatable on a dynamically created table is a better approach or directly using datatables API for forming the table dynamically is better? As it takes time for initialization step and the raw table is shown first than styled table.
  
  Also I think I would have to put customization and other features in setTimeOut function as those changes won't be applied unless the table is formed.
  
  Please give some suggestions as to which approach is better in my scenario.
  
  Thanks.