Replies

• allan Posts: 63,368Questions: 1Answers: 10,449 Site admin

  September 2014 edited September 2014

  "data": "table1.company_name AS 'name1'"

  I don't think that is in the documentation anywhere - and if it is could you point it out to me so I can remove it? Aliases are not supported in the data option and likely never will be.

  What does your returned JSON data look like? Basically you want to use the columns.data option to set the property name of the data you want to use for that column.

  Allan
• scooby Posts: 6Questions: 1Answers: 0

  September 2014 edited September 2014

  Yeah I could not find anything on this within the documentation anywhere so that's why I resorted to the forums.

  On another note, I did remedy my situation by setting the columns.data back to normal and then simply adding a small tweak to the server.php code.

  So my datatables initialization code was like so:

  $('#my-table').DataTable({
      "processing": true,
      "serverSide": true,
      "ajax": {
          "type": "POST",
          "dataType": 'json',
          "url": '/server.php'
      },
      "columns": [
          {
              "title": "Company Name 1",
              "data": "table1.company_name"
          },{
              "title": "Company Name 2",
              "data": "table2.company_name"
          }
      ]
  });
  

  And then when collecting all the columns within the server.php code I added a small check like so to add the column alias name:

  $cols = array();
  foreach ($columns as $column) {
      switch ($column['data']) {
          case 'table1.company_name':
              $cols[] = $column['data'] . " AS 'name1'";
              break;
          case 'table2.company_name':
              $cols[] = $column['data'] . " AS 'name2'";
              break;
          default:
              $cols[] = $column['data'];
              break;
      }
  }
  

  Then the rest of the script worked as it normally does..

  Thanks very much for the reply and confirming that Allan!
• allan Posts: 63,368Questions: 1Answers: 10,449 Site admin

  September 2014

  Good to hear you got it working.

  Allan