Overwrite table data with DataTables

Question

Overwrite table data with DataTables

Navigation

#1 by (0 votes)

2

Every time I make a change in the select, it calls this function, it picks the id of the selected tax and searches for the (daughters) tax rules, I need to update the table every time it changes. DataTables warning: table id = imposed rules - Can not reinitialise DataTable. For more information about this error, please see link

function pesquisaRegrasImpostos(imposto){
    if (imposto != "") {
        $.ajax({
            url: '/pesquisa/regraimposto/${imposto}',
            success: function(data){
                $("#regrasimpostos").DataTable({
                    "processing": true,
                    "serverSide": true,
                    "ajax": '/pesquisa/regraimposto/${imposto}',
                    "columns": [
                        {"data" : "impostoNome"},
                        {"data" : "modelo"},
                        {"data" : "pessoa"},
                        {"data" : "contribuinte"},
                        {"data" : "estado"},
                        {"data" : "cfop"},
                        {
                            "data" : null,
                            defaultContent: '<a href="#" title="Editar" data-id="impostoID" onclick="editarRegra('variavel')"><i class="edit icon"></i></a>'
                        }
                    ]
                })
            },
            error: function(error){
                alert(JSON.stringify(error));
            }
        });
    }
}

javascript jquery jquery-datatables

asked by anonymous 24.12.2018 / 13:53

1 answer

Error 4 The type 'System.Data.Entity.DbContext' is defined in an assembly that is not referenced video does not respect predefined height and object-fit: cover in Google Chrome

score 0 · Accepted Answer

You should not initialize the component more than once, just as it does not make sense to perform two ajax requests to populate the table, see that you do one at the beginning of your function, and another when you declare the url in the% of the ajax constructor.

Initialize the component only once, when loading the page, and use your api to change the content, ajax.url (). load () .

$(document).ready(function() {
  $("#regrasimpostos").DataTable({
    "processing": false,
    "serverSide": false,
    "data" : null,
    "columns": [{
        "data": "impostoNome"
      },
      {
        "data": "modelo"
      },
      {
        "data": "pessoa"
      },
      {
        "data": "contribuinte"
      },
      {
        "data": "estado"
      },
      {
        "data": "cfop"
      },
      {
        "data": null,
        defaultContent: '<a href="#" title="Editar" data-id="impostoID" onclick="editarRegra('variavel')"><i class="edit icon"></i></a>'
      }

    ]
  });
});



function pesquisaRegrasImpostos(imposto) {
  if (imposto != "") {
    var datatable = $("#regrasimpostos").dataTable().api();
    datatable
      .ajax
      .url('/pesquisa/regraimposto/${imposto}')
      .load();

  }
}

@import '//cdn.datatables.net/1.10.19/css/jquery.dataTables.min.css'

<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script><scriptsrc="//cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>
<table id="regrasimpostos" class="display">
  <thead>
    <tr>
      <th data-name="impostoNome">Nome</th>
      <th data-name="modelo">Modelo</th>
      <th data-name="pessoa">Pessoa</th>
      <th data-name="contribuinte">Contribuinte</th>
      <th data-name="estado">Estado</th>
      <th data-name="cfop">CFOP</th>
      <th></th>
    </tr>
  </thead>
  <tbody>
  </tbody>
</table>