Search

New New - docs: Add documentation for dependent() Fixes Fix - docs: i18n.remove.confirm incorrectly used %s in the documentation as the plural substitution. It should be %d Fix - docs: Remove two private methods from the generated PHP documentation that shouldn't have been shown in the public interface

Fix: Inline editing could result in making the table uneditable (until reload) due to an event listener not being removed. This was ultimately caused by the close method not being triggered. This was particularly noticeable if using tab control or the Ajax response from the server was very slow. Fix: submitComplete wasn't being triggered if there was an Editor field or form error (valid JSON required - it was being triggered in the case where invalid JSON was returned) Fix: Inline editing in IE10- with return submit could activate button click methods on elements that are not related to Editor Fix: Improved keyboard accessibility for the form submit buttons Fix: use data as the property to automatically determine the field to be edited for inline and bubble editing, rather than the name. Typically they are the same, but don't need to be. Fix: Radio fields may not always be updated if they are detached from the DOM Fix: Button class needs a space to separate it from the main form button class Fix: Style error in lightbox code - extra semi-colon (jshint) Fix: Missing semi-colons (jshint) PHP Fix - PHP: Exception could occur when trying to read data that does not exist Fix - PHP: If a leftJoin refers to a field that isn't included, no action is taken on it Fix - PHP: minMaxNum validator had a typo in it causing it to fail Docs Fix - docs: Typos in add() and select documentation Fix - docs: ajax.data had an incorrect link in it Examples Fix - example: Tab control used the on prefix for events from 1.2 Fix - example: Remove setInterval from inline tab example Fix - example: Inline tabbing - tab control should only be activated when inline editing Fix - examples: Typos in simple and field defaults examples Fix - examples: Typo of 'Extension' in examples

Fix: Attach submit event directly to the form element Fix: Remove debug statement Fix: fields with name=0 were causing an error Fix: Bootstrap integration error for title setting Fix PHP: A join with a table alias could cause a PHP error Fix PHP: Compatibility with PHP 5.3 when checking for a closure Fix PHP: PHP 5.3 compatibility for server-side processing Fix PHP: Field class could show an error on create Fix examples: Add missing standalone example index page Fix examples: Typos Fix examples: Demo tabs weren't quite working in the examples Fix examples: REST demo needed database name to be updated Fix examples: REST example needed a path update

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

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.