Search

That'll do it :). Good to know you've got it working now. Allan

Yeap thank you , works perfect !!

Documentation is here: https://docs.microsoft.com/en-us/previous-versions/office/developer/office-xp/aa140066(v=office.10)?redirectedfrom=MSDN There are also plenty of posts in here about customisation.

Thanks Kevin! that did the trick. Originally, I had put the containing division in the dom specification for the datatable, because otherwise the datatable was appearing in different part of the page. But I must have resolved in the interim. This is only Week 3 of developing in Django and using jQuery plugins and Ajax, so I have been doing a lot of feeling my way through things. After your simplification, I was able to simplify the ajax update to only update the table in the on success ajax function: success: function(response) { console.log('ajax success function'); console.log('tableTitle2: ' + (tableTitle || ' ')); //the call below refreshes the html for the //the plain HTML table with id resultTableId //that is bound to the datatable $('#resultTableId').html(response); console.log('after html response update'); }, and I no longer need to re-instantiate/bind the DataTable on ajax completion. I only need to update the Titles that are in the division above the DataTable. $( document ).ajaxComplete(function() { console.log('ajaxComplete'); // comment out - no longer necessary // as we did not replace the division with its contents //including the DataTable //we only updated the html table with id resultTableId // that the DataTable is bound to //the existing DataTable updates itself with the new //resultTableId contents // varResultDataTable = $('#resultTableId').DataTable({ // destroy: true, // paging: false, // scrollY: 400, // responsive: true, // order: [], // ordering: false, // dom: 'Bfrti', // buttons: [ // 'copyHtml5', // 'excelHtml5', // 'csvHtml5', // 'pdfHtml5' // ], // }); //update the title and description of the table above the DataTable element elemTableTitle = document.getElementById("table_title"); elemTableDesc = document.getElementById("table_description"); if (tableTitle.length > 0) if (elemTableTitle) elemTableTitle.innerHTML = tableTitle; if (tableDesc.length > 0) if (elemTableDesc) elemTableDesc.innerHTML = tableDesc; });

Thank you so much Colin. I've been studying the link you point out and I can't figure out why in my case $(table.column(5).footer()).text() does not work but I have found another solution to my problem in this other link: https://datatables.net/forums/discussion/22490 table.column(5).search() works perfectly, even with hidden columns. Thanks!!

Javascript. Then in the footerCallback, assuming that is what

Hi @DimitrisS , 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

Very nice, I'll take it to my project. Thanks

I built a simple test case for you: http://live.datatables.net/sifinelu/1/edit It uses the code from the example to build the options. I added var count just for illustration purposes. It appends the value of count to the option label so you can see it runs each time loaded. The value is 0 when initialized the increments each time the "Reload" button is clicked. Changed your initComplete option to this so it can pickup the Datatables API to pass to your dtFilter() function: initComplete: function() { dtFilter(this.api()) } Kevin

Without seeing your code or a test case as Kevin says, its impossible to say for sure, but if you are summing a calculated column you need to use cells().render() to get the calculated value, and then sum that. Allan