Answers

• kthorngren Posts: 21,205Questions: 26Answers: 4,927

  November 2022 edited November 2022

  You have ajax: result,. The ajax option expects a URL but you are passing in a JSON result. I see two options:

  1. Use data to supply Datatables with the data instead of ajax, for example: data: result,
  2. Remove the jQuery ajax() code you have above .done(...) and let Datatables fetch the data via the ajax URL using the ajax option

  Kevin
• Lander Posts: 9Questions: 3Answers: 0

  November 2022 edited November 2022

  I've already tried

      function CargarTabla() {
          var dato = $('#numeroFactura').val();
          dato += '|' + $('#cuf').val();
          dato += '|' + fechaInicio;
          dato += '|' + fechaFin;
          var miUrl = '@Url.RouteUrl(new{ action= "CargarTabla", controller= "EmiteAnulacion", dato = "_dato" })';
          miUrl = miUrl.replace('_dato', dato);
          tabla.ajax.url(miUrl).load();
          tabla.draw();
  

  with this option it does not load the data, but it does not give an error either

  Edited by Kevin: Syntax highlighting. Details on how to highlight code using markdown can be found in this guide
• Lander Posts: 9Questions: 3Answers: 0

  November 2022

                  <table id="tblDetalle" class="table" cellspacing="0" style="width:100%">
                      <thead>
                          <tr>
                              <th>@Html.LabelFor(x => x.nroFactura, new { @class = "col-form-label" })</th>
                              <th>@Html.LabelFor(x => x.cuf, new { @class = "col-form-label" })</th>
                              <th>@Html.LabelFor(x => x.numeroDocumento, new { @class = "col-form-label" })</th>
                              <th>@Html.LabelFor(x => x.nombreRazonSocial, new { @class = "col-form-label" })</th>
                              <th>@Html.LabelFor(x => x.montoTotal, new { @class = "col-form-label" })</th>
                              <th>@Html.LabelFor(x => x.fechaEmision, new { @class = "col-form-label" })</th>
                              <th></th>
                          </tr>
                      </thead>
                      <tfoot>
                          <tr>
                              <th>@Html.LabelFor(x => x.nroFactura, new { @class = "col-form-label" })</th>
                              <th>@Html.LabelFor(x => x.cuf, new { @class = "col-form-label" })</th>
                              <th>@Html.LabelFor(x => x.numeroDocumento, new { @class = "col-form-label" })</th>
                              <th>@Html.LabelFor(x => x.nombreRazonSocial, new { @class = "col-form-label" })</th>
                              <th>@Html.LabelFor(x => x.montoTotal, new { @class = "col-form-label" })</th>
                              <th>@Html.LabelFor(x => x.fechaEmision, new { @class = "col-form-label" })</th>
                              <th></th>
                          </tr>
                      </tfoot>
                  </table>
  

  there's something i'm not seeing
• kthorngren Posts: 21,205Questions: 26Answers: 4,927

  November 2022

  with this option it does not load the data, but it does not give an error either

  Its hard to say without seeing the rest of the code.

  Seems like the easiest option is number one in my first response. Did you try that?

  If you still need help the best thing to do is to post a link to your page or a test case replicating the issues so we can help debug.
  https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case

  Kevin
• Lander Posts: 9Questions: 3Answers: 0

  November 2022

  Thanks Kevin, using data works, however I still don't know why the instruction doesn't work: table.ajax.url(myUrl).load();
  Use the done option to test the data returned by the server.
  the solution i need is using table.ajax.url(myUrl).load();
• kthorngren Posts: 21,205Questions: 26Answers: 4,927

  November 2022 edited November 2022

  I still don't know why the instruction doesn't work: table.ajax.url(myUrl).load();

  The small code snippet is not enough to help debug. We will need to understand the code flow better to debug. You can start by using the browser's network inspector. Do you see the XHR request and response when the ajax.url().load() is executed?

  I built this sumple example to show it works:
  http://live.datatables.net/gomegike/1/edit

  You will see the Start Date column change to [object Object] as the new url has object data for that column. You can find the base example here:
  https://datatables.net/manual/tech-notes/9#Ajax

  If you can't post a link to your page then maybe you can update my example to show the problem.

  Kevin
• Lander Posts: 9Questions: 3Answers: 0

  November 2022

  thanks again for your support.
  I need the page to start with an empty table, to later load on demand according to a data filter.
  managed to make an example.
  http://live.datatables.net/yaxubipe/1/edit
• kthorngren Posts: 21,205Questions: 26Answers: 4,927

  November 2022 Answer ✓

  Take a look at the browser's console. You are getting this error:

  Uncaught TypeError: Cannot read properties of undefined (reading 'url')

  You have tabla = $('#example').dataTable( { which is the problem. To get an instance of the Datatable API you need to use tabla = $('#example').DataTable( {. Notice teh upper case D. See this FAQ for more info.

  Updated example:
  http://live.datatables.net/yaxubipe/2/edit

  Kevin
• Lander Posts: 9Questions: 3Answers: 0

  November 2022

  Yes, I found out after I sent.
  I already found the solution, I thought to use ajax.url().load(), it still doesn't work for me, but I think it's something with c#.
  Anyway fix the problem by resetting the table before calling again.
  Your help was very helpful, thank you very much