Getting the Datatable Server-side ID

Question

I’m using the Datatable Server-side, but I’m not sure how to catch the ID from my table to open the edit and delete pages.

server-side

$table = 'financ_receita';

$primaryKey = 'ID_Receita';

$columns = array(
    array( 'db' => 'ID_Receita',    'dt' => 0 ),
    array( 'db' => 'nome',          'dt' => 1 ),
    array( 'db' => 'valor',         'dt' => 2 ),
    array( 'db' => 'dataVenci',     'dt' => 3 ),
    array( 'db' => 'formaEntrada',  'dt' => 4 ),

);

Table mount

var myTable =
  $('#dynamic-table').DataTable({
    "processing": true,
    "serverSide": true,
    "ajax": "dados.php",
    "columns": [{
        "bVisible": false,
        "bSortable": false
      },
      null,
      null,
      null,
      null,
      {
        data: null,
        className: "center",
        defaultContent: '<a href="editar?id=" class="editor_edit button blue">Editar</a> <a href="excluir?id=" class="editor_remove button red">Del</a>',
        orderable: false,
        bSearchable: false,
      }
    ],
    "language": {
      "url": "/assets/js/dataTables/lang/pt-br.json"
    },
  });

I’d like to put the Id_recipe in the respective links: editar?id= and excluir?id=.

Answer 1

For dynamic elements, use render instead of defaultContent:

render: function(data){
   return '<a href="editar?id='+data[0]+'" class="editor_edit button blue">Editar</a> <a href="excluir?id='+data[0]+'" class="editor_remove button red">Del</a>'
},

The value in data[0] represents the data in the first column, i.e. ID_Receita.

See what it says to documentation concerning the defaultContent:

This option is available for those use cases - Creating Static content for a column. If you Wish to create Dynamic content (i.e. based on other data in the Row), the columns.render option should be used.

Free translation:

This option is available for cases where the content is static. If wants to create dynamic content (i.e., based on other data from table row), the option columns.render should be used.