Search

It doesn't work that way <div id="datatable-with-export" data-datatable='{ "pageLength": 15, "ordering": false, "scrollY": "470px", "pagingOptions": { "pageBtnClasses": "btn btn-text btn-circle btn-sm" }, "layout": { "top2": "searchPanes", "top1": { "buttons": [ { "extend": "copy", "className": "btn btn-primary btn-outline btn-sm", "text": "Копировать" }, { "extend": "csv", "className": "btn btn-primary btn-outline btn-sm", "text": "CSV" }, { "extend": "excel", "className": "btn btn-primary btn-outline btn-sm", "text": "Excel" } ] } }, "searchPanes": { "controls": true, "layout": "columns-2", "cascadePanes": true, "initCollapsed": true, "i18n": { "collapseMessage": "Скрыть фильтры", "showMessage": "Показать фильтры", "clearMessage": "Сбросить фильтры", "title": "Активные фильтры - %d" } }, "columnDefs": [ { "searchPanes": { "show": true }, "targets": [0] }, { "searchPanes": { "show": true }, "targets": [1] }, { "searchPanes": { "show": false }, "targets": [2] }, { "searchPanes": { "show": false }, "targets": [3] }, { "searchPanes": { "show": false }, "targets": [4] } ] }' <script> window.addEventListener('load', () => { const dataTable = new HSDataTable('#datatable-with-export', { columnDefs: [ { targets: [-1], render: function(data, type, row) { var cleanedData = data.replace(',', '.'); var num = parseFloat(cleanedData).toFixed(2); return isNaN(num) ? '' : num; } } ] }); }); </script>

I would say its nearly impossible to debug the non-working code without seeing the problem replicated. Your code has a lot going on and it will take someone else a lot of time to come up to speed to understand your solution. One way to get development help with your solution is to use one of the Datatables support packages. Kevin

@kthorngren I am super stressed right now.. I cannot get it working. I accidentally deleted the fiddle in the OP and now I can't recreate what I had working, it tells me that rows() is not defined? https://jsfiddle.net/BeerusDev/gm10rqp7/355/

Looks like you found this thread which Colin shows a working example to update the fixedColimns with fixedColumns().update(). Does this not work for you? If not please update his example or provide a test case showing the issue so we can help debug. https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case Kevin

Shame on me. You are totally right! I just needed to put "{filter:'applied'}" behind the functoin, of rows(). Thank you

I am adding the rows dynamically in the init method. Can you provide an example of how you are doing this? The example adds search to every header row before the table is created. They can be moved to initComplete, for example: http://live.datatables.net/sanuwidi/1/edit It dynamically creates the second header and applies the correct search input type based on class. Didn't modify the code much from teh other examples much to make it work. Kevin

Please don't post duplicate questions. See the answer in your other thread. Kevin

I'm afraid you'll need to clarify your question What execution date? I don't see any date code in the code you pasted above. Allan

Thank you!

I asked Allan Jardine to make a custom version for us that supported that functionality. I think you can ask him to develop it. He asked us only for a small contribution. Best regards, Danilo Pompei