Skip to main content

Questions tagged [datatables]

DataTables is a plug-in for the jQuery JavaScript library. It is a highly flexible tool, based upon the foundations of progressive enhancement, which will add advanced interaction controls to any HTML table. Do not use this together with [datatable].

1 vote
0 answers
30 views

Get all CELLS from a specific Datatable ROW

So I'm adding a row to my datatable using var newRow = myTable.row.add([ questionText, '', '', '', '', '' ]).draw(false); And I then want to get all the cells from that row ...
0 votes
0 answers
28 views

This filter in datatables is not working for filtering more than one word

It works properly for one word categories, however if there are spaces in between it doesn't show results.I'm not quite sure how to fix it, can you please check my code and let me know what is not ...
2 votes
1 answer
12k views

datatables bootstrap modal not working

I am trying to get a click to open editable content of my dyniamically generated rows in modals, using datatables plugin. I see an error: Uncaught TypeError: Cannot read property 'display' of ...
0 votes
2 answers
8k views

jQuery datatable export to excel with cell(<td>) background color

PFB is my code sample: https://codepen.io/avinash-reddy95/pen/eYzORmJ. <script type="text/javascript"> $(document).ready(function () { var table = $('#example')....
0 votes
1 answer
54 views

order from recent date DataTables dd/mm/yyyy

I made a table using DataTables plugin. I created a column called "Date" which contains some dates. With the button near "Date" I can order records but I have to use this format ...
2 votes
2 answers
841 views

Datatable scroll x issue using fixedColumn

im using jquery datatables with fixedColumns. Everything working fine but im having an issue with scroll x. As u can see, i cant remove the scroll x from fixed column. Any ideas to solve this? ...
0 votes
0 answers
22 views

Toggle b/w two jquery datatables

I am new to jquery and want to implement jquery datatables for my project. $(document).ready(function () { function destroyDataTable(table) { if ($.fn.DataTable.isDataTable(table)...
0 votes
0 answers
26 views

Server Side DataTables warning: table id=DataTables_Table_0 - Ajax error

I'm getting an error when trying to setup a datatables with my project. DataTables warning: table id=DataTables_Table_0 - Invalid JSON response. For more information about this error, please see http:/...
72 votes
12 answers
258k views

How to redraw DataTable with new data

I have checked several questions already about this topic here in stackoverflow, but they are all using the old dataTable. I am using DataTable. I populated my DataTable by NOT USING server side, so ...
0 votes
1 answer
53 views

export to excel using datatable

I want to export to excel. here is my code. $('#tabelku').dataTable({ dom: 'Bfrtip', "buttons": [{ ...
4 votes
3 answers
11k views

How do I center the entire DataTable in the pdf using JQuery pdfHtml5

I'm loving using $('#tableId').DataTable() and the "pdfHtml5" button to generate a PDF. I just can't figure out how to center the information within the generated PDF. A Table with only two columns ...
-1 votes
1 answer
60 views

Remove all rows of table using jQuery

I have a javascript function that insert new rows in Table using jquery. This is the code: $.each(data,function(i,item){ $('#tb-articoli').dataTable().fnAddData( [ ...
0 votes
1 answer
16 views

Subtract date from database with current date in datatables

I have a date stored in database in YYYY-MM-DD format. I want to subtract the date with current date to calculate difference in years. My code looks like this: <table id="my_table"> &...
0 votes
0 answers
33 views

Connecting PyCharm to Apache Spark Docker Containers Running on Windows Host via WSL

I have Apache Spark set up in Docker containers running on my Windows host machine using WSL (Windows Subsystem for Linux) environment. I would like to connect PyCharm, which is running directly on ...
0 votes
0 answers
22 views

DataTables 1.10 - column width is not working as expected

I have defined a datatable per the below. I am using bootstrap 5. I have read this thread but I still cannot get column width to work. I have tried to change the width using 5%, 500%, 100%, 5px, ...

15 30 50 per page