How to reload full datatable, evenif row and col change numbers e data??

GeasLu

Link to test case: not possibile
Debugger code (debug.datatables.net): ??
Error messages shown: no error
Description of problem: My datatable load data from an ajax call and the number of columns depend from an interval of date. For example I have 2 params data_start-> 01/01/2021 and data_end->31/12/2021, so i will load 1 column for each month(12) if my paramas change, for example 01/06/2021->31/12/2021 I have to load only 6 column(1 for each month). But something wrong...first I try to use destroy() and empty(), but i lose graphic format and everycolumns is not allign with header, then i try clear().draw() but it's ok for data, but remain my header old and new in the same tabel!

How can i realoda fully datatabel?

GeasLu

Here is my code if ajax call success:

                    dtb = $('#' + pIdDataTable).DataTable({
                        destroy: true,
                        responsive: true,
                        data : result['ValueCol'],
                        dataSrc : "ValueCol",
                        selectType : "row",
                        "fnDrawCallback": function( oSettings ) {
                            $(".sparkline" ).sparkline('html', {width: '70px', height: '30px'} );
                        },
                        language:{
                            "lengthMenu": "_MENU_ righe"
                        },
                        //"scrollX": true,
                        columns: result['HeaderCols'],
                        dom: '"<\'row mb-3\'<\'col-sm-12 col-md-6 d-flex align-items-center justify-content-start\'f><\'col-sm-12 col-md-6 d-flex align-items-center justify-content-end\'B l>>" +\n' +
                            '                        "<\'row\'<\'col-sm-12\'tr>>" +\n' +
                            '                        "<\'row\'<\'col-sm-12 col-md-5\'i><\'col-sm-12 col-md-7\'p>>"',
                        columnDefs:elnDefCol(result['IndexesColDef'])
                    });
                    dtb.columns.adjust().draw();
                    break;

colin

We're happy to take a look, but as per the forum rules, please link to a test case - a test case that replicates the issue will ensure you'll get a quick and accurate response. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here.

Cheers,

Colin