Replies

• grahambr Posts: 5Questions: 0Answers: 0

  October 2011

  Sorry..I posted this to the wrong category and dont know how to change it to the right one. :(
• fbas Posts: 1,094Questions: 4Answers: 0

  October 2011

  I presume your rows in the first table have a uniquely identifying column/data, like order number.
  
  based on this order number, your ajax would query the database and get data for the 2nd table.
  
  probably easiest way to implement would be to use fnFilter(ordernum, ordercolnum) for that 2nd table
  
  in pseudo-code:
  [code]
  when user clicks on row in table 1,
  1. get order number from some column in that row in table 1
  2. call oTable2.fnFilter(ordernum, ordercolnum) where ordercolnum is the column in table 2 that contains the order number for each of the products in the order
  3. magic. DataTables does the rest
  [/code]
• grahambr Posts: 5Questions: 0Answers: 0

  October 2011

  Thanks. I appreciate it. Please dont hate me for some obvious (Perhaps) questions.
  
  'oerdernum' in your above example would be the value passed from the first oTable, or is the name of the column in thefirst one? Im not sure exaclty how to pass ordernum, do I just implement one of the tables with a callback?
  
  Im not exactly sure how to link the 2 tables also.. I understand the concept but syntax-wise...
  
  would oTable2.fnFilter be in oTable1, or is that in the oTable2 definition?
  
  Here is that I am thinking you are saying:
  
  DEFINE oTABLE1
  - oTable2.fnFilter(ordernum, ordercolnum)
  -
  
  Then
  
  DEFINE oTable2
  
  
  There isnt an example of this somewhere is there?
• fbas Posts: 1,094Questions: 4Answers: 0

  October 2011

  datatable 1 and datatable 2 are completely different tables in html/datatables.
  
  it sounds like they will be completely different tables in the database as well.
  
  table 1 lists all orders
  
  table 2 allows you to list all parts of an order (all rows in table 2 that have a reference in some field to an order number)
  
  ---
  
  the call to oTable2.fnFilter() would be in whatever handler you are using to detect the user clicking on a row in oTable1. likely it is not specified within the initialization object of table1, but something like:
  
  [code]
  $(document).ready( function () {
  oTable1 = $('#table1').dataTable(
  // ....
  );
  oTable2 = $('#table2').dataTable(
  // ....
  );
  
  $('#table1 tbody tr').live('click', function() {
  // find the order number (I'm assuming it's in column 0 of every row)
  aData = oTable1.fnGetData(this);
  sOrder = aData[0];
  
  // filter table 1 with this order number (assuming order number is in col 4 of table 2)
  oTable2.fnFilter(sOrder, 4);
  })
  });[/code]