Search

Fix: JS - Remove trailing white-space for JSHint Fix: JS - dateFormat validator would not allow empty values (dateFormat_required) is the validator to use for required fields so this was little wrong. Fix: JS - date fields which were added using add() after Editor had been initialised were not being correctly initialised as a date field. Fix: JS - order() when called, when the form is visible has no immediate effect. Fix: JS - Server-side processing with aliased names was broken Fix: JS - The old DTValidate class was being incorrectly referenced. Should be Validate Fix: JS - update for radio didn't select current value Fix: JS - Checkbox update doesn't reselect current values - 14081 Fix: JS - Radio field type was always type casting as string, breaking boolean Fix: JS - i18n with multiple instances used only the strings from the last instance Fix: Docs - edit() example had a typo, was using the create() method! Fix - examples: Bootstrap integration should use $().on() rather than the old $().live() method. Fix - examples: Manager was not being correctly selected Fix - examples: Deep object delete wasn't working due to an incorrect property read Fix: PHP, Postgres - Table aliases would break the query due to invalid SQL

Fix: api:clear - Fix ordering issue, where ordering wasn't updated on a clear - 13566 Fix: api:clear - Fix clearing field 0 - 13566 Fix: api:documentation - Example for fields didn't actually use the method that it was supposed to be showing! Fix: PHP - When submitting an empty array (i.e. a checkbox array with no items set) the HTTP parameter isn't sent to the server, resulting in an error being reported - 12820. Fix: examples - Missing the 'title' field from the formOnlyData example so the title input was completely ignored - 12644 Fix: integration:bootstrap - If the user exited the Bootstrap modal using the esc key, the Editor for could not be brought back onto screen as it thought it was still open. Fix: Add type="text" to the text input fields. Fix: When multiple instances of Editor were used, the display controllers were both attaching multiple events (one for each instance) rather than just using events for the instance that was being worked with. This would result in display events (such as close) being fired multiple times. The fix is to attach events, not at init time as was done before, but rather the events are attached, for a single instance on each display, and removed on close ensuring that the events only apply to the active instance. It is worth noting that the display controller DOM elements are still shared between the instances to help keep memory usage to a minimum - this works here as the two built in display controllers can only show one instance at a time, but if a display controller were to provide the ability to interact with multiple tables at the same time (a modal for example) it would need to use an individual DOM element for each instance. See thread 12563 for the original bug report.

Web-site: Correct links to the self-referencing documentation

Fix - Core: Using Editor without loading TableTools would result in a Javascript error, due to setting the language preferences without checking for the existence of TableTools first. Fix - PHP: Validation of required fields was a little broken due to an incorrect string length calculation. Fix - PHP: ORDERY BY (order method) had a couple of issues which caused it to work incorrectly, which are now fixed. Fix - PHP: Query prototype was out of date - also needs port passed in (i.e. 5 parameters) Fix - PHP: Check that the joining field has been included in the Editor field list - otherwise it won't work and it is fairly obscure as to why not. Fix - PHP: When joining tables, before we assumed that the primary key that is defined in the Editor class would be used for the join, but this isn't always true - its likely to be usually true, but not always. Instead, the parent field from the join statement is now used. As noted, this will usually be the pkey of the parent, but doesn't need to be any more. Also worth noting that the field that is used for the join must be in the Field list for the Editor instance - since the pkey is by default, this isn't normally a problem.

Fix - docs: Error in the 'ajax' method example where 'method' was missing Fix: When working with checkboxes and switching between different editing records, old checked checkboxes were not cleared, resulting in checkboxes being incorrectly checked for a record. Fix: 'update' method for the select list incorrectly used the old set of options rather than the new set passed in. Fix: If no options are passed into the select field it would generate an error. Now you simply get an empty list (the idea being that you would use the 'update' field method to add items at some point after initialisation

Fix: If a non-array non-string (i.e. a numeric value) was passed to the radio control, it would cause a Javascript error on the 'split' this is now addressed. Fix: IE7 needs key binding events to be attached to document rather than windwo Fix: IE7 fires the window resize event early (page initialisation) which could cause a script error. Fix: IE7 wouldn't apply a default selection to checkboxes Fix: Syntax highlighting of the init code and xhr send/response was not working well in IE6/7/8 - it does now. Fix: When the lightbox is already shown, and you request it to be shown again, it would set the opacity to be 0 and then fade back in, resulting in an ugly flash. It now maintains state and will only perform its fading as and when needed.

First public release of DataTables Editor, bringing full CRUD capabilities to DataTables in an easy to use and flexible package.

Select the styling framework that you wish to use from the buttons below: DataTables Bulma Bootstrap 3 Bootstrap 4 Bootstrap 5 Foundation jQuery UI Fomantic UI The following packages can be installed for DataTables core and its extensions: # DataTables core npm install datatables.net-dt # AutoFill npm install datatables.net-autofill-dt # Buttons npm install datatables.net-buttons-dt # ColReorder npm install datatables.net-colreorder-dt # FixedColumns npm install datatables.net-fixedcolumns-dt # FixedHeader npm install datatables.net-fixedheader-dt # KeyTable npm install datatables.net-keytable-dt # RowGroup npm install datatables.net-rowgroup-dt # RowReorder npm install datatables.net-rowreorder-dt # Responsive npm install datatables.net-responsive-dt # Scroller npm install datatables.net-scroller-dt # SearchBuilder npm install datatables.net-searchbuilder-dt # SearchPanes npm install datatables.net-searchpanes-dt # Select npm install datatables.net-select-dt # StateRestore npm install datatables.net-staterestore-dt

2015-08-27: ColReorder and Buttons' column visibility module are now compatible with the release of Buttons 1.0.1. 2015-11-06: Responsive is compatible with Buttons' column visibility as of Responsive 2.0.0. 2015-11-06: Responsive is compatible with DataTables' child row API as of Responsive 2.0.0 as it now provides an option to display the hidden information in a modal view. 2016-02-04: Select and FixedColumns are fully compatible as of DataTables 1.10.11, FixedColumns 3.2.1 and Select 1.1.1. 2020-01-10: Add SearchPanes. 2020-09-15: Add SearchBuilder. 2020-09-15: SearchPanes is compatible with SSP as of v1.1. 2021-06-03: Remove Flash export for Buttons. Not supported as of v1.7 2021-08-25: DataTables 1.11.0 means that Internet Explorer 8+ required. 2021-08-25: SearchBuilder is compatible with SSP as of v1.2. 2021-09-10: FixedColumns 4.0.0 IE no longer fully supported with FixedColumns AutoFill now fully supported with FixedColumns ColReorder now fully supported with FixedColumns Editor now fully supported with FixedColumns FixedHeader now fully supported with FixedColumns KeyTable now fully supported with FixedColumns RowReorder now fully supported with FixedColumns 2021-09-10: FixedHeader 3.2.0 Scrolling now fully supported with FixedHeader RowGroup now fully supported with FixedHeader Scroller now fully supported with FixedHeader 2021-09-24: Add StateRestore.

AutoFill bower install --save datatables.net-autofill bower install --save datatables.net-autofill-dt Buttons bower install --save datatables.net-buttons bower install --save datatables.net-buttons-dt Please note that the excelHtml5 button depends upon JSZip which is available as the bower package Stuk/jszip, while the pdfHtml5 button depends upon pdfmake which is available as the bower package pdfmake. ColReorder bower install --save datatables.net-colreorder bower install --save datatables.net-colreorder-dt FixedColumns bower install --save datatables.net-fixedcolumns bower install --save datatables.net-fixedcolumns-dt FixedHeader bower install --save datatables.net-fixedheader bower install --save datatables.net-fixedheader-dt KeyTable bower install --save datatables.net-keytable bower install --save datatables.net-keytable-dt Responsive bower install --save datatables.net-responsive bower install --save datatables.net-responsive-dt RowGroup bower install --save datatables.net-rowgroup bower install --save datatables.net-rowgroup-dt RowReorder bower install --save datatables.net-rowreorder bower install --save datatables.net-rowreorder-dt Scroller bower install --save datatables.net-scroller bower install --save datatables.net-scroller-dt SearchPanes bower install --save datatables.net-searchpanes bower install --save datatables.net-searchpanes-dt Select bower install --save datatables.net-select bower install --save datatables.net-select-dt