title: Get the values from jQuery Datatable hidden columns
body: <p>I have a jQuery datatable populated with info from a db' table and I have hidden two columns, now I need to get the value from the two hidden columns but I couldn´t, this is the code of my datatable and had set the property visible: false for the two last columns</p>
  
  <pre><code>    $('#myTable').DataTable({
          searching: false,
          paging: true,
          responsive: true,
          ordering: false,
          bInfo: false,
          bLengthChange: false,
          processing: true,
          info: false,
          deferRender: true,
          orderMulti: false,
          "ajax": {
              "url": "../home/CargarTabla?id=" + noDocumento,
              "type": "GET",
              "datatype": "json"
          },
          "columns": [
                  { "data": "nombres", "autoWidth": true, "orderable": false },
                  { "data": "apellidos", "autoWidth": true, "orderable": false },
                  { "data": "dui", "autoWidth": true, "orderable": false },
                  { "data": "numero_isss", "autoWidth": true, "orderable": false },
                  { "data": "cargo_participante", "autoWidth": true, "orderable": false },
                  { "data": "genero", "autoWidth": true, "orderable": false, "visible": false },
                  { "data": "nivel_puesto", "autoWidth": true, "orderable": false, "visible": false },
                  { "defaultContent": " &lt;a href='#' id='select'&gt;Modificar&lt;/a&gt;  ", "autoWidth": true, "orderable": false }
          ],
          "oLanguage": {
              "sEmptyTable": "No hay registros disponibles",
              "sInfo": " _TOTAL_ registros. Mostrando de (_START_ a _END_)",
              "sLoadingRecords": "Por favor espera - Cargando...",
              "sSearch": "Filtro:",
              "sLengthMenu": "Mostrar _MENU_",
              "oPaginate": {
                  "sLast": "Última página",
                  "sFirst": "Primera",
                  "sNext": "Siguiente",
                  "sPrevious": "Anterior"
              },
              "oAria": {
                  "sSortAscending": ": Activar para ordenar la columna de manera ascendente",
                  "sSortDescending": ": Activar para ordenar la columna de manera descendente"
              }
          }
      });
  </code></pre>
  
  <p>and this is the way I get the value from the columns that are visible to the user, it works just fine:</p>
  
  <pre><code>$("#myTable").on('click', '#select', function (e) {
              e.preventDefault();  
              var currentRow = $(this).closest("tr");
              var Nombres = currentRow.find("td:eq(0)").text();
              var Apellidos = currentRow.find("td:eq(1)").text();
              var DUI = currentRow.find("td:eq(2)").text();
              var ISSS = currentRow.find("td:eq(3)").text();
              var Cargo = currentRow.find("td:eq(4)").text();
  
              alert(Nombres + Apellidos + DUI +ISSS+ Cargo);
          });
  </code></pre>
  
  <p>But how I get the values from the hidden columns? I have tried this in the <code>$("#myTable").on('click', '#select', function (e)</code> with no success </p>
  
  <pre><code> alert(table.row(this).data()[5]);
   alert(table.row(this).data()[6]);
  </code></pre>
  
  <p>other way with no success</p>
  
  <pre><code>var row = $(this).parents("td")[0];
  var pos = oTable.fnGetPosition(row);
  var Genero = oTable.fnGetData(pos[5])["idGenero"];
  </code></pre>
  
  <p>and last</p>
  
  <pre><code>  var arr = $('#myTable').dataTable().fnGetData($(currentRow));
              var Genero = arr[5]; 
              var Nivel = arr[6];
  </code></pre>
  
  <p>could you please help me to get the values from the hidden columns with the script code showed? BTW this is the HTML code</p>
  
  <pre><code>&lt;div class="table-responsive"&gt;
      &lt;table class="table table-striped table-condensed" id="myTable" style="width:100%; margin:0 auto;"&gt;
          &lt;thead&gt;
              &lt;tr&gt;
                  &lt;th&gt;Nombres&lt;/th&gt;
                  &lt;th&gt;Apellidos&lt;/th&gt;
                  &lt;th&gt;DUI&lt;/th&gt;
                  &lt;th&gt;ISSS&lt;/th&gt;
                  &lt;th&gt;Cargo&lt;/th&gt;
                  &lt;th&gt;Sexo&lt;/th&gt;
                  &lt;th&gt;Nivel&lt;/th&gt;
                  &lt;th&gt;&lt;/th&gt;
              &lt;/tr&gt;
          &lt;/thead&gt;
  
          &lt;tbody&gt;&lt;/tbody&gt;
      &lt;/table&gt;
  &lt;/div&gt;
  </code></pre>