Closed 4 mins ago.

Closed 4 mins ago.

`Problem:
We have built a feature in DataTables that allows users to copy an existing record. This feature lets users edit only the required fields (approximately 20+ fields) assuming that the majority of the data remains the same. However, this requires the user to change at least 4 to 5 dropdown fields at a minimum on the “copied” record.

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.

datatables version – 2.0.1

I’m new to JS and DataTables and have inherited this code.

I need to filter the Area 1, Area 2, and Area 3 (columns 2, 3, and 4) in the “Area” dropdown, without displaying duplicates. Here is my table: https://www.berkshirecc.edu/_training/test/employee-directory-1.php.

I added the columnDefs array to my DataTables initialization code. The purpose is that the column with index 0 can be sorted according to the values in the hidden column with index 1.

I’m working with jQuery DataTables and I’m trying to customize the layout of my DataTable, specifically the positioning of the control buttons. I want to move the DataTable buttons to a different location than the default. Here’s the current dom configuration I’m using:
dom: "<'row dom_wrapper fh-fixedHeader'B<'col-sm col-md'>f<'col-sm col-md'>i<'col-sm col-md'>l>" + "<'row'<'col-sm col-md'tr>>" + "<'row'<'col-sm col-md'i><'col-sm col-md'p>>",
This layout places the buttons (B), filtering input (f), table information (i), and length changing input (l) all in the same row. However, I would like to:

I am using the CellEdit repo https://github.com/ejbeaty/CellEdit and this plug-in works great for Datatables client-side. However, when I use Datatables server-side (AJAX calls to get data) with CellEdit, the updating cell keep reverting back to old value after it updated with new value. I monitored the Console window under Browser Inspector and noticed the cell is actually updated with new value, then the cell reverts to old value when it is finished. I couldn’t figure out how to stop it from reverting back old value.